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.
I'm building out some sample data. I have a very simple data set that looks like this:
Unit | Count | Spend | Month | Relative Month |
Box | 1,234 | $100 | October | Current |
Box | 5,678 | $801 | October | Current |
Bag | 9,123 | $900 | September | Previous |
Bag | 1,234 | $200 | September | Previous |
My hope is to create a simple KPI visual that shows the current month's performance (one visual for spend, one visual for count) and the +/- for the relative month. So, what I'd hope to see above is a large 6,912 representing units for the current month, then a Goal value of 10,327 (reprsenting prior month) and a % of -33% representing the difference between the current month and the prior month (goal).
I have built measures representing units for current and prior month, etc. Right now my field list looks like this:
It just shows the prior month's value and the goal as the same number. I've also tried moving my Units Current Month measure to value and this just generates a Blank in the visual itself. Any thoughts?
Solved! Go to Solution.
Hi, @bensiqc ,
I tried something real quick:
Total Units Current =
CALCULATE(
[Total Units],
'KPI'[Relative Month] = "Current"
)
Total Units Previous =
CALCULATE(
[Total Units],
'KPI'[Relative Month] = "Previous"
)
Total Units = SUM('KPI'[Count])
Hi, @bensiqc ,
I tried something real quick:
Total Units Current =
CALCULATE(
[Total Units],
'KPI'[Relative Month] = "Current"
)
Total Units Previous =
CALCULATE(
[Total Units],
'KPI'[Relative Month] = "Previous"
)
Total Units = SUM('KPI'[Count])
Thanks! This works. Seems like my issue was that I didn't make an explicit Units measure and was instead using the 'sum of units' column in the dataset itself.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |