Forum Discussion
Conditional show columns with dynamic headernames
Hello All,
I want to make a dashboard table with columns:
- Which I can show/hide conditional, based on a filterselection.
- Which I can change the formula of, based on a filterselection.
- Wich I want to give dynamic names, based on a filterselection.
Thanks in advance!
Halmar
1 Reply
- amitchandakSuper User
Halmar , Based on what I got
- Which I can show/hide conditional, based on a filterselection. - Not very clear - Measure slicer or axis slicer
- Which I can change the formula of, based on a filterselection.- Measure slicer
- Which, I want to give dynamic names, based on a filterselection. - You can create a measure have dynamic title not name, you can use a calculation group if needed
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYMEcalculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/Axis Slicer
Three approch from Guyinacube https://www.youtube.com/watch?v=dYmzb5UMkXw
Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated