Dynamic Buttons

[BSM1985]

Hello Team,

As per requirement, I would need to have the slicers in the form of buttons as shown in below screenshot.

Case 1: Choose Year 2015 from slicer -->click on Month button then it should all months in 2015 year in the form of buttons. Please refer below screenshot. Then if users click on Month lets say June then the graph should be plotted for June Month.

Case 2: Choose Year 2015 from slicer -->click on Quarter button then it should all Quarters in 2015 year in the form of buttons. Please refer below screenshot. Then if users click on Quarter lets say Q2 then the graph should be plotted for Q2 Quarter.

Case 3: Click on Year button then it should all years in the form of buttons. Please refer below screenshot. Then if users click on Year lets say 2015 then the graph should be plotted for 2015.

.pbix file here
https://1drv.ms/u/s!ArRkjWtfVLy-bcQVKOgszO1vXds

screenshots here

[Sumanth_23]

hi @BSM1985 - you can do this using bookmarks; see screen grabs below for the way to implemetn

Havent used github too much but let me know if you can access the PBI file in path below: https://github.com/Sumanth23/PBI_Files

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[BSM1985]

Thanks @Sumanth_23 @DataZoe  @Greg_Deckler  for taking time to look into this.

Is there anyway we can achieve this with help of static table (Enter Data). Becasue users have suggested us to avoid bookmarks for this kind of scenarios for their own reasons. Can you please advice..if this is possible.

[Greg_Deckler · Accepted solution]

@BSM1985 Something like: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...

[BSM1985]

Thanks a lor @Greg_Deckler . I will modify the code as per my requirement. This will guide me how to do so.

[DataZoe]

@BSM1985 I think the trick here would be bookmarks:

I've modified your file and uploaded it here: https://github.com/DataZoe/PBIX/blob/master/Tabs2-working.pbix 

[Greg_Deckler]

@BSM1985 I can think of a couple options.

1. Buttons and Bookmarks

2. Something like: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...