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.
Good Afternoon,
I'm trying to create a line chart based of the below example data to plot tickets raised each day.
The issue I'm having is that when no tickets are raised on a particular date the value isn't set to 0.
How can i achieve this?
Solved! Go to Solution.
Hi @Anonymous ,
Create a calendar table and create a relationship between the two tables based on date column.
Create measure like this:
Measure = IF(ISBLANK(SUM('Table'[Value])),0,SUM('Table'[Value]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Create a calendar table and create a relationship between the two tables based on date column.
Create measure like this:
Measure = IF(ISBLANK(SUM('Table'[Value])),0,SUM('Table'[Value]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Change the axis type to categorical. Another way put marker so that is known that data is not there on those days.
+0 in the calculation is a bad option to have, it will even remove date filter.
Hi @Anonymous
Add a date dimension/calendar table as below if you haven't.
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
If you have a table with only closed records then create a measure like:
Measure = COUNTROWS( closedTable )
if you have more statues in this table then:
Measure = COUNTROWS( CALCULATETABLE( Table, Table[status]= "Closed" ) )
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |