Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer Parameter Tabl

[joshua1990]

Hello everyone!

I have seen the fantastic video of RADACAD of how to use a parameter table to filter between some measures.

https://www.youtube.com/watch?v=_sxLEGRCo28

This approach is really awesome!

I need to extend this approach to filter between the current month and the current week.

For this purpose, I have two additional binary columns (True / False)  in the calendar table: Current Month and Current Week.

The approach above is working with the SELECTEDVALUE and SWITCH function.

I have created a new table with one column and the two values "MTD" and "WTD" that are referenced in the SELECTEDVALUE Measure.

How can I add the binary columns Current Month & Week into the SWITCH Function?

[Greg_Deckler]

@joshua1990 - Sample data would help me visualize what is going on. This might help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...

This might be a Disconnected Table Trick. If that is the case see this article: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...