Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Miller1971
Regular Visitor

Bar Chart Categories Not showing when data filtered.

Good morning everyone. 

I'm producing a bar chart to show discrete data.  The output of machines. We have 12 machines and I would like to see the data for all machines even if zero.  I have selected "show items with no data" and also put +0 to the end of the calculation. 

When I choose a large time scale filter on the visualisation . E.g year , all 12 machines data is visible.  However I report on data from the previous working day.  If those machines haven't been used in the previous working day.  I'm struggling how to include a value of zero also.

Appreciating anyones help .

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors