cancel
Showing results for
Did you mean:
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

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

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

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

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.
Regular Visitor

## Re: Slicer threshold based on raw column value

Thanks for the help!

How do I create a calculated table?

Highlighted
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.
Regular Visitor

## Re: Slicer threshold based on raw column value

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.

Regular Visitor

Thanks!

Moderator

## Re: Slicer threshold based on raw column value

@swong,

Create your table visual as follows.

Then use the column in the ValueTables to create slicer.

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.

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 42 members 971 guests
Recent signins: