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.
Hi All,
I am faced with a challenge. I have a page with many visuals and a year and month filter. I want to add another visual on this page that when the user select a month (e.g Oct ) and year (e.g 2019), the visual should display a curve from Oct 2018 to Oct 2019.
My measure is: total_end = sum(interruption([END])
I have a date dimension which is connected to interruption fact table.
The problem I have right now is that when I select Oct 2019. The curve only display a single point "oct 2019"
What can I do to solve this ?
Solved! Go to Solution.
I ended up solving the problem by creating the measure below:
end_last_n_months = CALCULATE( [total_end], DATESINPERIOD(DimDate[Date], MAX(DimDate[Date] ),-12, MONTH ) )
and then on my axis, I used the date column from the facts table.
I ended up solving the problem by creating the measure below:
end_last_n_months = CALCULATE( [total_end], DATESINPERIOD(DimDate[Date], MAX(DimDate[Date] ),-12, MONTH ) )
and then on my axis, I used the date column from the facts table.
Hi @Anonymous
You need Two Date Dimensions / Calendar table to achieve your requirement.
The below measure needs to be used in the visual you want to display 12 months.
I've attached the file with the example.
Measure = VAR _drs = MAX( Dates[Date] ) VAR _dre = DATE( YEAR( _drs ), MONTH( _drs ) -12, DAY( _drs ) ) RETURN CALCULATE( SUM( 'Table'[Value] ), ALL( Dates ), FILTER( 'Dates ( second )', AND( 'Dates ( second )'[Date] <= _drs, 'Dates ( second )'[Date] >= _dre ) ) )
Let me know how you get on.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |