Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

how to load only headers on table visual at first

Hi,

 

        i have  a report with a slicer and a table visual in report.I need only headers to load firstly and values should be based on the users selection on slicers.Is it possible?

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,
    Yes it is possible. First, you need to create a measure based on slicer selection.

     

    show blank first = CALCULATE ( IF ( ISFILTERED ( TableName[collumn] ), 1, 0 ), ALLSELECTED ( TableName) )
    Then in the filter pane for the table visual set it to 1.

     

    Regards,

    Ashfiya

    --------------------------------------------------------------------------------------------------------------------------

    Did I help you today? Please mark my post as a solution and hit the Kudos button.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,
    Yes it is possible. First, you need to create a measure based on slicer selection.

     

    show blank first = CALCULATE ( IF ( ISFILTERED ( TableName[collumn] ), 1, 0 ), ALLSELECTED ( TableName) )
    Then in the filter pane for the table visual set it to 1.

     

    Regards,

    Ashfiya

    --------------------------------------------------------------------------------------------------------------------------

    Did I help you today? Please mark my post as a solution and hit the Kudos button.