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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
MariaP
Solution Supplier
Solution Supplier

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

 

Nil FiltersNil FiltersFilter Selected for row with blank dataFilter Selected for row with blank data

Anonymous
Not applicable

Hi @MariaP

 

Thanks for your response!

 

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

Hi again,

 

My solution in the file is here:

 

Download

 

This is almost the same as  #Thejeswar has posted.

 

Thanks

Maria

 

 

Anonymous
Not applicable

Hi Maria

 

Not able to download the file.

 

Could you please send the DAX here.

Hi again,

 

Create these 2 measures.

Use Model as your filter and for you Axis

Use Display Total in your Value for your bar graph.

 

Total Model = SUM('Sample'[Count]) 
Display Total = If(ISBLANK([Total Model]),0, [Total Model])

Cheers,

Re-created link also included.

I have accessed OK. Not sure why this does not work .

https://www.dropbox.com/s/ql3wuq7a1jz9tla/Aishwar04.pbix?dl=0

Stating the obvious, but this is what I see when I try to download....

 

AClickDownloadButton.PNG

Hi,

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

 

 

Anonymous
Not applicable

Hi Team

 

Anyone with an idea for this issue. 

Hi @Anonymous,

You can use the below DAX Statement

 

Measure1 = IF(ISBLANK(Measure),0, Measure) 
Anonymous
Not applicable

Hi Thejeswar

 

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

Hi @Anonymous,

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 slicedAll the data is displayedAll the data is displayed

 2. When the data is slicedThe Pack Size 2-GPI still has the quantity to be blankThe 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.

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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