Forum Discussion
Different columns based on selection - calculation groups
Hi all!
I want to build a report with a slicer on the top that has 2 fields - 2 different Measures:
- Measure A
- 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?
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.
2 Replies
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!
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.
