topic Re: Need help on Bar chart having value switch slicer and Top performer Or All values slicer in DAX Commands and Tips

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

GyanendraMaurya — Wed, 29 Dec 2021 21:27:19 GMT

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 .

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

themistoklis — Wed, 29 Dec 2021 21:41:20 GMT

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'

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

GyanendraMaurya — Thu, 30 Dec 2021 10:29:12 GMT

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.