Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 l...
Need Help
MariaP's avatar
MariaP
Icon for Solution Supplier rankSolution Supplier
8 years ago

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 FiltersFilter Selected for row with blank data

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    MariaP
    Icon for Solution Supplier rankSolution Supplier
    8 years ago

    Hi again,

     

    My solution in the file is here:

     

    Download

     

    This is almost the same as  #Thejeswar has posted.

     

    Thanks

    Maria

     

     

    • Thejeswar's avatar
      Thejeswar
      Icon for Super User rankSuper User
      8 years ago

      Hi,

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

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Maria

       

      Not able to download the file.

       

      Could you please send the DAX here.

      • MariaP's avatar
        MariaP
        Icon for Solution Supplier rankSolution Supplier
        8 years ago

        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....