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.
Hey Team,
Im trying to display blank values as 0 and tried to add that to the chart.
Total Tickets = CALCULATE(COUNTA('Data'[Ticket])+0)
When I try to use this to the bar graph it shows me all the months from 2020 and 2021 for some reason.
How would I be able to just show Dec 2020, Jan 2021 and Feb 2021 (Last 3 months)
Solved! Go to Solution.
HI @Anonymous,
I'd like to suggest you add a variable to extract and store the current date. Then you can add an 'if statement' to package your expression and compare it with the current date and block some calculations on not wanted ranges.
Total Tickets =
VAR currDate =
MAX ( Calendar[Date] )
VAR prevDate =
DATE ( YEAR ( currDate ), MONTH ( currDate ) - 3, DAY ( currDate ) )
RETURN
IF (
MAX ( 'Data'[Date] ) >= prevDate
&& MAX ( 'Data'[Date] ) <= currDate,
CALCULATE ( COUNTA ( 'Data'[Ticket] ) + 0 )
)
Regards,
Xiaoxin Sheng
HI @Anonymous,
I'd like to suggest you add a variable to extract and store the current date. Then you can add an 'if statement' to package your expression and compare it with the current date and block some calculations on not wanted ranges.
Total Tickets =
VAR currDate =
MAX ( Calendar[Date] )
VAR prevDate =
DATE ( YEAR ( currDate ), MONTH ( currDate ) - 3, DAY ( currDate ) )
RETURN
IF (
MAX ( 'Data'[Date] ) >= prevDate
&& MAX ( 'Data'[Date] ) <= currDate,
CALCULATE ( COUNTA ( 'Data'[Ticket] ) + 0 )
)
Regards,
Xiaoxin Sheng
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |