Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Don't show data before user selects from slicer

In a report, I need to hide the data in a table visual until users selects a value from the slicers.  They NEVER need/want to see all the data.  I have seen it done and it looks so easy!  The report ...
'DAX'
'Need help'
  • Anonymous's avatar
    Anonymous
    2 years ago

    I found the answer! It seems to matter where you attach the measure you want to use for this functionality. I have one main data source - a Snowflake SQL view. This did not work when I attached the measure to that data source even when the measure seemingly correctly indicated whether the slicer data item was filtered or not.


    I created a unique table with the column that I needed to have in the slicer and attached the measure to that created table and it worked perfectly!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Design red flag.

 

Remember that in Power BI "nothing selected"  is (mostly) equivalent to "everything selected".  There's a small difference between "filter hasn't been touched yet" and "nothing selected"

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for that correction, lbendlin .  I still need to add that functionality to the report.  I believe that my methodology is correct (please tell me if that is not the case), but I cannot get the report to function as I require.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      The difference in values is caused by different filter contexts. You can use a measure as a filter, but only on an individual visual, not on an entire page, for exactly that reason.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        lbendlin, thanks for the quick reply and that makes sense.  I am using the measure as a filter on the individual visual – not the page.  As I stated, with the filter on the visual, I can show or hide the data in the table if I hardcode the measure with a 0 (hide) or 1 (show).  I don't understand why this DAX code doesn't work:

        Filtered = int(ISFILTERED(EBI_USER_DETAIL_FINANCE_SAP_EXPORT_V[SERVDATE]))