Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Blank visuals by default

Hi everyone 🙂 I have a sliser with three values, one of them being (Blank). How do I make the Blank default choice so when an end-user opens the report, he sees all visuals empty until he choses eit...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Try a dax as follows:

IsBlankCheck = IF(ISFILTERED(CD[name]), 1, 0)

 

Move this to your visual on your page in visual level filter with "1" selected. So, when you select a slicer value in CD[name], the visual will display result, otherwise it will show blank visual.

 

Thanks,

Pragati

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Pragati11 sorry i didn't get it. Should I replace 1 and 0 with the non-blank names?

    and when I move the measure to the filter on that visual, the advanced filter appears. Should I choose is 1?

     

    • v-zhenbw-msft's avatar
      v-zhenbw-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

       

      We can create a new table that contains one column and a measure to meet your requirement.

       

      1. Create a table that get the distinct name column.

       

      Name_table = VALUES(CD[name])

       

       

      2. Then we create a slicer using this column and create a measure.

       

      Measure = 
var _selected = SELECTEDVALUE(Name_table[name])
return
IF(_selected="",BLANK(),CALCULATE(SUM(CD[value]),FILTER(CD,CD[name]=_selected)))

       

       

      If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

      It will be helpful if you can show us the exact expected result based on the tables.

       

      Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

       

      BTW, pbix as attached.

       

      Best regards,

       

      Community Support Team _ zhenbw

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      6 years ago

      Hi Anonymous ,

       

      Yes select 1 in here.

       

      Thanks,

      Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Pragati11 I applied the filter (Show items when the valus is 1). But it is still shows all three slicers. 

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      6 years ago

      Hi Anonymous ,

       

      Is it possible to share your pbix file? You can share it as a private message if you can't share the .pbix file here.

       

      Thanks,

      Pragati