Forum Discussion
Slicer based on column names
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
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
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.
4 Replies
- amitchandak
Super User
Anonymous , refer if this can help
- AnonymousNot applicable
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
Super User
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
Community Support
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.