Slicer based on column names

[Anonymous]

Hi!

I have 6 caculkated columns in my Power BI report, called  Actuals, Cummulative Actual, Planned , Cummulative Planned, Forecast and cummulative Forecast. I have build a bar & line  chart based on these columns. Now I want to build a slicer /filter on this report so I can filter and see them individually and see the charts. Basically I want a slicer with three selection option "Actual", "Planned" and "Forecast" categories. Would reallyb appreciate if someone has done this and can help out.

Kind regards

[amitchandak · Accepted solution]

@Anonymous , you have the above way, have multiple visual one above another and use bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may create bookmarks for every slicer options, for references: Use bookmarks to share insights and build stories in Power BI , Dynamic Visuals using Buttons.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

[Anonymous]

Thanks for your reply but it does not seem to work with the suggestion in the link. The issue is my columns are calculated columns and I am just looking to get the column Names on the slicers so when I select individually , it doisplays the chart against that.

[amitchandak · Accepted solution]

@Anonymous , you have the above way, have multiple visual one above another and use bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive