Dynamic Column Based on Slicer

[TimmK]

I have a table visual in my report. In this visual I want to use a column that should dynamically change based on my slicer selection.

Is this possible?

The reason for this is that I want to keep the report slim and reduce the number of report tabs. I already use SELECTEDVALUE and bookmarks for measures so I can quickly change between year, month and week in my column visuals. Adding further bookmarks would interfere between the different types of bookmarks I think. But maybe there are even more possibilities to accomplish what I look for?

[AlanFredes · Accepted solution]

Hi @TimmK,

I think using Field Parameters might get you wat you want. You can add grouping numbers to it and then build a relationship between the slicer columns and the Field Parameter calculated table to select the columns you need based on another slicer selection.

Documentation: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

let me know if you need more details or help.

Regards,

Alan Fredes

Did I answer your question? Mark my post as a solution!