Blank Visuals

Question

Hi Team&nbsp;I have a bar chart and upon selecting certain values values in slicer it goes blank. I have used the ISBLANK() in the measure that is being used in the bar chart. Is there a way to show like "Data not available" or 0 in such cases. Quick help will be appreciated.&nbsp;

anonymous · Answer

Hi Team&nbsp;Anyone with an idea for this issue.&nbsp;

thejeswar · Answer

Hi&nbsp;Anonymous,You can use the below DAX Statement&nbsp;Measure1 = IF(ISBLANK(Measure),0, Measure)

anonymous · Answer

Hi Thejeswar&nbsp;I have already used this in DAX but the visuals still go blank upon slicing.

mariap · Answer

Hi&nbsp;Aishwar04&nbsp;&nbsp;Is this what you are trying to achieve? If so, I will post quick solution.&nbsp;Please post your desired outcome and some data to help answer your question.&nbsp;When I select Mazda, Visual remains with&nbsp;zero&nbsp; data as the&nbsp;result.&nbsp;&nbsp;&nbsp;Maria&nbsp;Nil FiltersFilter Selected for row with blank data

thejeswar · Answer

Hi&nbsp;Anonymous,I tried replicating your scenario. But I am not able to replicate it&nbsp;Here is my screenshot in two cases&nbsp;1. When the data is not slicedAll the data is displayed&nbsp;2. When the data is slicedThe Pack Size 2-GPI still has the quantity to be blank&nbsp;In the above 2 cases, Measure and Measure2 column values are unchanged.&nbsp;Here the Measure column is the one where the Blank is handled using the below DAX statement&nbsp;Measure = IF(ISBLANK(SUM('Merge Table'[Quantity])),0, SUM('Merge Table'[Quantity])) The Measure2 is without BLANKs handledMeasure 2 = SUM('Merge Table'[Quantity])In both the cases, the data looks fine.&nbsp;&nbsp;

Forum Discussion

Blank Visuals

10 Replies

Related content

Replace blank with 0 in matrix visual

Power BI Online Service Visuals are blank

Blanks showing in table visual

Map Visual is Blank

Deneb visual exports blank to PowerPoint while standard Power BI visual exports correctly