Dynamically choose columns and measures based on a slicer

[Anonymous]

Hi!

I have a table with columns and measures: Order number, customer name, country, a sum of amount, quantity, and order count. I am using a table to visualize this data.

What I would like to do is I want to show these columns and measures on the table based on the user's selection on a slicer. For example, When a user selects an Order number, I want to show this on the table. I like the user to choose from a selection which columns and measures to see on the table. What should I do to get that work?

[v-henryk-mstf]

Hi @Anonymous ,

There is a strong interactivity between the visuals in the PowerBI Desktop report. When the Order number field is added to the slicer, different data is filtered, and the table visual will display different results according to the filtered content.

like this:

If I have not resolved your doubts, can you provide more detailed information or test data, preferably with the expected results, so that I can solve your problem as soon as possible.

Let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Dynamic selection and replacement of measure is a bit different tasks.

Calculation group can help measure

measure slicer

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

or
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

for column

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/