The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 .