cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swong Regular Visitor
Regular Visitor

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 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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Slicer threshold based on raw column value

@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.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Moderator v-yuezhe-msft
Moderator

Re: Slicer threshold based on raw column value

@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.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
swong Regular Visitor
Regular Visitor

Re: Slicer threshold based on raw column value

Hi @v-yuezhe-msft,

 

Thanks for the help!

 

How do I create a calculated table?

Moderator v-yuezhe-msft
Moderator

Re: Slicer threshold based on raw column value

@swong,

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

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
swong Regular Visitor
Regular Visitor

Re: Slicer threshold based on raw column value

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.

Highlighted
swong Regular Visitor
Regular Visitor

Re: Slicer threshold based on raw column value

Hi @v-yuezhe-msft,

 

Checking in about this question.

 

Thanks!

Moderator v-yuezhe-msft
Moderator

Re: Slicer threshold based on raw column value

@swong,

Create your table visual as follows.
1.JPG

Then use the column in the ValueTables to create slicer.
2.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.