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!

Anonymous's avatar
Anonymous
Not applicable
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!