Skip navigation

5 Replies Latest reply on Sep 28, 2017 3:50 AM by Tushar More

Need to show the data in dimesion filters based on measure values

saranya pakkiri Sep 28, 2017 2:23 AM

Hi,

I have used year,month parameters and followed by filters. My dimension filter should show only relevant values based on measure. Even though if i set relevent values in quick filter it acts as cascading but it is not filtereing for measures. Could anyone of you help me on this.

Eg: Region filter should show based on measure values.

East-1

south-4

Here I have data only for east and south. So my Region should show east and south instead of all regions.

Thanks,
Saranya

1. Re: Need to show the relevant data in filters when measure having values

Tushar More Sep 28, 2017 2:30 AM (in response to saranya pakkiri)

could you please post a sample workbook.

~Tushar
Like Show 0 Likes(0)

Actions
2. Re: Need to show the data in dimesion filters based on measure values

saranya pakkiri Sep 28, 2017 2:34 AM (in response to Tushar More)

Hi Tushar,

I don't have sample data and workbook. What my need is to filter the dimension value based on measures. Hope you got my point.

Thanks,
Saranya
Like Show 0 Likes(0)

Actions
3. Re: Need to show the data in dimesion filters based on measure values

Tushar More Sep 28, 2017 3:04 AM (in response to saranya pakkiri)
Check the attached file created v 10.3.

Let me know if it helps.

~Tushar

demo.twbx 33.7 KB
Like Show 0 Likes(0)

Actions
4. Re: Need to show the data in dimesion filters based on measure values

saranya pakkiri Sep 28, 2017 3:10 AM (in response to Tushar More)

Hi Tushar,

Could you please save it in 10.0 Version. It would be helpful for me.

Thanks,
Saranya
Like Show 0 Likes(0)

Actions
5. Re: Need to show the data in dimesion filters based on measure values

Tushar More Sep 28, 2017 3:50 AM (in response to saranya pakkiri)

I don't have v10.3.

I placed measure to the filters shelf and converted to discrete dimension.

Hope this helps.

~Tushar
Like Show 0 Likes(0)

Actions

Go to original post

More Like This