Forum Discussion
Helper IDisplay 0 in Clustered Column Chart
Just create a simple date table and use it to the chart.I dont understand your third requirement.Do you want show the application count for past 7 days from today?
Check out your power bi file attached ito the link..
https://dropfiles.org/cedwMsVu
I have just created a extra date column into the source in order to make the relationship.
Regards,
sanalytics
if it is your solution please like and please accept it as your solution
Community SupportHi sanalytics ,
You need to create a 'Calendar Table' firstly.
"If it's possible, I would like it to display 0 on X axis even if there was no records on this day (display 0 on November 25)"
Enable "Show items with no data." feature.
"Also I need to display curent day and 0 on this day even if there is no records today (display 0 on November 28)"
The calendar table can achieve the idea.
"Show only records occured (or show zeros if there wasn't any) for the past 7 days"
You need to create a measure and add it to the "Filters on this visual" pane.
Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.