Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
AdrienPU
New Member

Dynamic Column in Matrix Visual

I have a single Table in POWER BI Table called "Dynamic Comparison" with only 6 columns
1 Dimension Column called "Cost Center"
1 Dimension Column called "GL Account"
1 Dimension Column called "New Category"
1 Dimension Column called "Date"
1 Dimension Column called "Attribute" (Values are "Budget 2024", "Forecast 2024", "Actuals 2023", "Actuals 2024"
1 Measure Column Called "Costs"

I would like to Build a Matric Visual with "Category" in Row Fied
I would like the user to be able to choose with a slicer visual wich "attribute" he wants to see as first Value and with a second slicer visual which "attribute" he wants to see as second value.

So that he as the freedom to chose if he want to see Budget vs Actuals/ Actuals vs Forecast/ Actual PY vs Actual AY is that possible

1 REPLY 1
lbendlin
Super User
Super User

Use Field Parameters on measures, or use Calculation Groups.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.