Hi,
I have a report requirement to build Clustered Column Chart. The data to present has quaterly numbers read from Azure AS cube. The data is present in a snow-flake schema with a single fact and few dimensions.
The fact measure value is a numeric field that would sit well in both visuals with quaters on the axis.
The end user has asked for a data handling scenarios where quarters should show up where there is no data available, which the bar graph skips.
Data coming into Power BI already has marking for those rows by indentifier of -123. Handled in the database/cube by adding additonal rows with unknown dim keys and indentifier of -123.
Problem I have is that I can play around with data to make -123 values to 0 and graph would show a blank quarter as zero value doesn't show up on bar graph. But when the report is downloaded the data will still show 0. Need a fix so that the data downloaded also has a blank.
Making the data textual to handle blank isn't working with bar graph which expects numerical values.
Any sggestions?
Cheers!!
