Forum Discussion

Matty's avatar
Matty
Icon for Helper II rankHelper II
8 years ago

What's the best method for toggling data?

Hi Team,   I'm looking for some guidance as to how best acheive the following.   I have table similar to the below:   Date Report Week 01/01/2018 No 08/01/2018 No 15/01/2018 No ...
Need Help
Matty's avatar
Matty
Icon for Helper II rankHelper II
8 years ago

Hi,

 

Reading up a bit more on this, it seems that calculated columns are only refreshed at query time and not at runtime.

 

This means that one is not able to user a slicer to influence (change) values within a table - a slicer can only act on a table.

 

Anyone got any other suggestions?

 

Cheers,

 

Matty

thomasronn's avatar
thomasronn
Icon for Resolver I rankResolver I
8 years ago

Create a measure on you data table

Visible = IF( IF( ISFILTERED(Table2[Column1]), MAX(DataTable[Report Week]) = "Yes", TRUE()),1,0)

 

Add Visible to the filters on your visual and set it filtered to 1.

  • Matty's avatar
    Matty
    Icon for Helper II rankHelper II
    8 years ago

    Hi,

     

    Setting the visual filter to 1 removes the dynamic nature of the slicer though, unless I've missed something here?

     

    Cheers,

     

    Matty

  • Matty's avatar
    Matty
    Icon for Helper II rankHelper II
    8 years ago

    Just going to bump this one in case anyone else has any ideas...