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
I would like to know if it is possible to display all months for a graph but select a date in a slicer.
Like I want the full month value for January and February and month to date for March
Is it possible to create a measure to acheive this?
Thanks
Yes, you would need an ALL statement in there and then filter down to what you need. See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Thanks
But it seems like this measure does not behave like I want
Measure =
VAR _MAXYEAR = MAX( 'Date'[Year] )
VAR _TMPTABLE = CALCULATETABLE( 'Date'; ALL( 'Date'[Year] ); ALL( 'Date'[Month] ); ALL( 'Date'[Date] ) )
RETURN
SUMX(FILTER(_TMPTABLE; 'Date'[Year] <= _MAXYEAR);[Turnover Tax Excl EUR])
I tried to have all possible dates I could, but as a result, in my graph the only date displayed is 2020-03-16
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |