Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have 14 tables they are individual KPI tables with date,country and Actual values. Additionally i have created 3 tables one for Date,country and Target.
I am creating a Matrix visual. I am able to get categories and sub categories and metrics as an hierarchy in rows. Target is added separately in values. However when i add Actuals it is actually getting added as a separate columns. Please tell how i could add the average correctly.
Example:
Category Sub-cat Actual Target
A aa 55 100
B bb 60 100
I want it in above format but it is coming in below format
Category Sub-cat Actual Actual Target
A aa 55 100
B bb 60 100
Please help
@Anonymous
What is the structure of your tables?
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
it is going to be difficult to help solve the problem without seeing a sample of your tables (with false data if need be).
are the sum of actuals in your matrix summing up values form different columns?
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |