Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
I have created two Matrix visuals with two parameters that contain measures and work perfectly fine.
I want to make a third Matrix which will compare two Matrix visuals and show the differences.
When I did that in Tableau the formula was Parameter1-Parameter2, but in PowerBi I can't make calculated measures from Parameter Field that I am using in Matrix.
Can anybody solve this problem?
Sounds like Visual Calculations can help.
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...
Basically I have for example
Parameter 1 with values:
-Sum of Value May
-Sum of Orders May
Parameter 2 with values:
-Sum of Value Jun
-Sum of Orders Jun
I want to subtract Parameter 2 - Parameter 1.
Put everything in a single Matrix visual and then use Visual Calculations.
Unfortunately, it says :
"You can't use field parameters with visual calculations."
this is correct - it's a limitation that is mentioned in our docs.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.