Conditional show columns with dynamic headernames

[Halmar]

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

[amitchandak]

@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/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://www.youtube.com/watch?v=vlnx7QUVYME

calculation 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