Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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,
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,
Click the "New Table" option and apply the DAX formula I provide.
Regards,
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,
Create your table visual as follows.
Then use the column in the ValueTables to create slicer.
Regards,
Lydia
User | Count |
---|---|
94 | |
89 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |