cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aishwar04 Regular Visitor
Regular Visitor

Blank Visuals

Hi Team

 

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.

 

10 REPLIES 10
Highlighted
Aishwar04 Regular Visitor
Regular Visitor

Re: Blank Visuals

Hi Team

 

Anyone with an idea for this issue. 

Thejeswar Senior Member
Senior Member

Re: Blank Visuals

Hi @Aishwar04,

You can use the below DAX Statement

 

Measure1 = IF(ISBLANK(Measure),0, Measure) 
Aishwar04 Regular Visitor
Regular Visitor

Re: Blank Visuals

Hi Thejeswar

 

I have already used this in DAX but the visuals still go blank upon slicing.

MariaP Regular Visitor
Regular Visitor

Re: Blank Visuals

Hi Aishwar04

 

 

Is this what you are trying to achieve? If so, I will post quick solution.

 

Please post your desired outcome and some data to help answer your question.

 

When I select Mazda, Visual remains with zero  data as the result.  

 

Maria

 

VisualNilFilter.PNGNil FiltersVisualBlankSelected.PNGFilter Selected for row with blank data

Thejeswar Senior Member
Senior Member

Re: Blank Visuals

Hi @Aishwar04,

I tried replicating your scenario. But I am not able to replicate it

 

Here is my screenshot in two cases

 

1. When the data is not slicedCapture1.PNGAll the data is displayed

 2. When the data is slicedCapture2.PNGThe Pack Size 2-GPI still has the quantity to be blank

 In the above 2 cases, Measure and Measure2 column values are unchanged.

 

Here the Measure column is the one where the Blank is handled using the below DAX statement

 

Measure = IF(ISBLANK(SUM('Merge Table'[Quantity])),0, SUM('Merge Table'[Quantity])) 

The Measure2 is without BLANKs handled

Measure 2 = SUM('Merge Table'[Quantity])

In both the cases, the data looks fine.

 

 

Aishwar04 Regular Visitor
Regular Visitor

Re: Blank Visuals

Hi @MariaP

 

Thanks for your response!

 

Yes, this is what I need to show 0 upon slicing instead of the visual going completely blank.

MariaP Regular Visitor
Regular Visitor

Re: Blank Visuals

Hi again,

 

My solution in the file is here:

 

Download

 

This is almost the same as  #Thejeswar has posted.

 

Thanks

Maria

 

 

Thejeswar Senior Member
Senior Member

Re: Blank Visuals

Hi,

Yes, the Matrix visual which I have used, when converted to a graph, "Measure" will show 0 wherever there are blanks

 

 

Aishwar04 Regular Visitor
Regular Visitor

Re: Blank Visuals

Hi Maria

 

Not able to download the file.

 

Could you please send the DAX here.