Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi, is it possible to highlight changes above e.g. 10% vs. the preceding month in a matrix visual?
The result is expected to look like this:
January | February | March | April | |
Sales | 10000 | 10500 | 9000 | 10000 |
variable costs | 3000 | 3150 | 2500 | 2700 |
fixed costs | 1000 | 1000 | 1000 | 1150 |
overhead costs | 500 | 1200 | 500 | 500 |
EBIT | 5500 | 5150 | 5000 | 5400 |
Thanks!
Solved! Go to Solution.
Then, use Sum(Amount) instead of YOURMEASURE
All numbers are in a single column and I have an attribute column ("line items")
Then, use Sum(Amount) instead of YOURMEASURE
Thanks, Olga!
yet I don't get it yet. What is [yourmeasure]? It doesn't seem like calculate accepts a column as first argument.
My data has the following columns:
Table Facts:
[Line item]: Sales, variable costs, fixed costs, overhead costs
[Amount]: numbers listed above
[calendar]: Year and month
[EBIT]: is a calculated column
Sum(Amount) is your measure, your numbers ,what you are displaying.
line items, what do you mean, those are the values in a column? or those are separate columns?
Format Measure =
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
105 | |
69 | |
48 | |
47 | |
47 |