Forum Discussion

swong's avatar
swong
Helper II
9 years ago
Solved

Slicer threshold based on raw column value

Hi,   Is it possible to create a threshold slicer based on a raw column value?   I have a column with values [10,20,30,40,50,60]. I want to create a slicer such that the value selected capture ev...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    swong,

    Firstly, create a calculated table using the DAX below.
    ValueTables = VALUES(Table[Column1])

    Secondly, create a measure in your original table.
    expectedresult = CALCULATE(SUM(Table[Column1]),FILTER(Table,Table[Column1] >= FIRSTNONBLANK(ValueTables[Column1],1)))

    Thirdly, create a slicer using the column of the newly created table.


    Regards,
    Lydia

swong's avatar
swong
Helper II
9 years ago

Hi Anonymous,

 

I see, thanks!

 

I created a sample .pbix with Delta values that are not bucketized. Is there a way to still apply the threshold slicer and display the raw column values? Here is the .pbix file: https://microsoft-my.sharepoint.com/:u:/r/personal/t-sewong_microsoft_com/_layouts/15/guestaccess.aspx?share=EXUkrC_4_PFPoZXKTYQuaRIBv6r3QZVj1AB6I59UlgumSw

 

Currently, the slicer doesn't filter the values showen, it just filters which rows show the slicer value.

swong's avatar
swong
Helper II
8 years ago

Hi Anonymous,

 

Checking in about this question.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    swong,

    Create your table visual as follows.


    Then use the column in the ValueTables to create slicer.


    Regards,
    Lydia