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 have following table
Date Category Values
2021Q2 | B | 10 |
2021Q4 | C | 23 |
2021Q4 | D | 24 |
2021Q1 | A | 56 |
2021Q1 | D | 41 |
2021Q4 | D | 87 |
2021Q4 | A | 90 |
2021Q3 | A | 45 |
I want to present it in the Matrix Visuals (it requires to be in Matrix Visuals) where user will choose any two dates from slicer
And I want to add another column to the right of the Matix which will shows percentage change between dates.
output should look like this but in Matrix Visual:
I wrote the following dax but it is not working plus it automatically renders two columns. How can I achive my goals? Any help will be appreciated!
Percentage_Change =
VAR SelectStartDate =
MIN ( 'Table'[Date] )
VAR SelectEndDate =
MAX ( 'Table'[Date] )
VAR CurrentValue =
CALCULATE (
SUM ( 'Table'[Values] ),
FILTER (
'Table',
'Table'[Date] = SelectEndDate
)
)
VAR PreviousValue =
CALCULATE (
SUM ( 'Table'[Values] ),
FILTER (
'Table',
'Table'[Date] = SelectStartDate
)
)
RETURN
( CurrentValue - PreviousValue ) / PreviousValue
Solved! Go to Solution.
where user will choose any two dates from slicer
How are you planning to enforce that?
Here is a version that simply uses the Min and Max quarter, regardless of how many slicer choices are made.
Caveat - you cannot suppress the single value total
Hi,
PBI file attached,
Hope this helps.
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 |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |