Different columns based on selection - calculation groups

[joshua1990]

Hi all!

I want to build a report with a slicer on the top that has 2 fields - 2 different Measures:

1. Measure A
2. Measure B

At the bottom I want to have a table visual that shows mutliple columns.

Is there any way to display different columns based on the slicer?

Maybe using calculation groups?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

You can try using field parameter feature in Power BI.

Use report readers to change visuals (preview) - Power BI | Microsoft Learn

Please check the below picture and the attached pbix file.

Like below picture, you can try to create group inside field parameter. 

[tharunkumarRTK]

@joshua1990 

If I understand correctly you want to swich the measures in the table based on the selection of a slicer. You can do in multiple ways and one easiest way is to use field paramters 

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

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!