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 need a KPI matrix with additive and semi-additive measures.
The time frame is month/year.
Installing PowerKPI Matrix I get something like this:
The 1st KPI "Cash flow" should ADD the whole year. But instead on the "Actual" column it is showing the value of the last month of the year.
How do I tell this visual "give me the sum of all the months for this KPI and the last date for others".
The actual value is a measure that distinguishes the additive from the semi-additive measures using a logical test with a combination of CALCULATE + LASTDATE filter.
Thanks!
hi, @webportal
I'm afraid you couldn't achieve it in PowerKPI Matrix. For other interactions are based on it, if you change the result by measure,
other interactions like Sparklines will be wrong.
and here is an example and introduction for PowerKPI Matrix, please try it.
Best Regards,
Lin
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |