Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 =
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
87 | |
68 | |
66 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |