Slicer threshold based on raw column value

[swong]

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 everything greater than or equal to it, i.e. if I select "10", then all data points with a column value >10 are visualized; if I select "50", only data points with a column value of 50 or 60 are visualized.

Is this possible, without having to create a parameter and reset it each time?

If the only was is to create a parameter, is it possible to change this parameter once I publish this report and create a dashboard?

[v-yuezhe-msft · Accepted solution]

@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]

Hi @v-yuezhe-msft,

Thanks for the help!

How do I create a calculated table?

[v-yuezhe-msft]

@swong,

Click the "New Table" option and apply the DAX formula I provide.

Regards,

[swong]

Hi @v-yuezhe-msft,

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.as...

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

[swong]

Hi @v-yuezhe-msft,

Checking in about this question.

Thanks!

[v-yuezhe-msft]

@swong,

Create your table visual as follows.


Then use the column in the ValueTables to create slicer.


Regards,
Lydia