Forum Discussion
Build a Slicer based on a measure
Hi Everyone,
I am trying to build a slicer based on a measure. That is I have a dynamic ranking based on the filtered data. Like examples below, pic1& pic2, I selected 'store' from category column, so right now I only have data for 'store', and "Ranking" meaure is dynamicly calculated. The same idea for the second picture.
What I want is a slicer based on this dynamic "Ranking", so I can slice and dice the range of the "Ranking", like from 1 to 5, or 5 to 7, etc, which I will be able to see the chord diagram from any parts I am interestned in. ( like pic3)
pic1
pic2
pic3
Any feedback will be highly appreciated! Thanks so much for reading!
Regards,
liuyuxinxin,
Sorry for incorrect information. It is not possible to drag measures to page level filter. And it is not possible create slicer using measure, there is an idea about this issue, you can vote it up.
Regards,
Lydia
6 Replies
liuyuxinxin,
It is not possible to create a slicer using a measure. But you can drag the measure to visual level filter of the table visual, then set value for the measure.
Regards,
LydiaAnonymous
Thanks so much, Lydia.
It helps, however it does not meet our users' expection.
1. the "Visual Level Filters" will not sync the table and the chart at the same time.
2. the "Visual Level Filter" will not be available after I publish it, so users wont see or use it.
I am new to PowerBI, apologize if there are solutions for above. Any feedback will be super helpful!
Thanks & Regards,
liuyuxinxin，
It is not possible to create a slicer using measure. You can create a calculated column to calculate rank, but the rank will not be dynamic.
To sync chart and table visual in a report page, you can drag the measure to Page level filter. To sync chart and table visual in all report pages, you can drag the measure to Report level filter.
Regards,
Lydia
