cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
liuyuxinxin
Regular Visitor

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

example 1.PNG

pic2

 

 

example 2.PNG

pic3 

 example 3.PNG

 

Any feedback will be highly appreciated! Thanks so much for reading!

 

Regards,

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Build a Slicer based on a measure

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Moderator v-yuezhe-msft
Moderator

Re: Build a Slicer based on a measure

@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.

1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
liuyuxinxin
Regular Visitor

Re: Build a Slicer based on a measure

@v-yuezhe-msft

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,
 

Moderator v-yuezhe-msft
Moderator

Re: Build a Slicer based on a measure

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sreenathv Solution Specialist
Solution Specialist

Re: Build a Slicer based on a measure

I think it's possible to create a slicer dynamically.

 

Can you take a look at the following article..

 

Dynamic Segmentation

 

 

liuyuxinxin
Regular Visitor

Re: Build a Slicer based on a measure

@v-yuezhe-msft

 

Really appreciate your help, Lydia! 

 

Unforuntately, we need rank to be dynamic.  I tried your way that drag down the measure to page level filter, but unfortunately, it did not work out for me. 

 

Any insights why PowerBI does not support a slicer on a measure? Would it be a good proposal or feature to be considered?

 

Thanks!

Moderator v-yuezhe-msft
Moderator

Re: Build a Slicer based on a measure

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors