Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
GyanendraMaurya
Frequent Visitor

Need help on Bar chart having value switch slicer and Top performer Or All values slicer

Hi,
I have a situation where I need to create a bar chat in power BI having a value selector ( I have 2 values) and a slicer where through which I can select Top performer (Ex Top 5) or All values. As shown in attached image.

As of now I have un-pivoted the table and able to achieve a value switch slicer for bar chat. I have tried many tricks for to create a slicer or button for All vs Top performer but nothing seems to be working.

Any help would be appreciated .Example_Image.PNG

2 REPLIES 2
GyanendraMaurya
Frequent Visitor

Hi @themistoklis ,

 

Thanks for your reply. I could use Bookmark but:

 

As of now I have two values to switch between for bar chart, now if I'll create bookmark, there will be 4 bookmarks created, top 5 + All for 1 value and same as for another.

 

Now by clicking any button ex ALL, I can open one bookmark lets say it opens Bookmark for value 1 - All now once I'll switch the bar chart value same All button is suppose to return a Bookmark for value 2 - All.

 

So now I'm not sure how should I use value selected in bar chart to let button decide which bookmark to open.

 

 

themistoklis
Community Champion
Community Champion

@GyanendraMaurya 

Why dont you use bookmarks which is a actually a snapshot of a report based on selected filters.

 

So one bookmark for 'All' values and another for 'Top 5'

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors