Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 =
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |