Forum Discussion
Slicer
Hello All,
I have requirement to use slicer with three fields "Total Potential savings" Total Weighted savings" and Total Actual Savings"
So that user can select any one to display the data in the graph.
These fields are mesures and are calculated like below.
Anonymous , you need a measure slicer to shift the measure, you need a filter on the values of the slicer?
measure slicer means choosing a measure to display on visual.
These are options
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYMEIn case you filter on measures like the value of saving between 1-100 etc. then it what I posted last. If you want I can try that on this file.
5 Replies
Anonymous , To create a measure slicer you need to use an independent table and use that. Using generate series or Enter data to create the range. You need to use it measures using group(values) and = or between
comparison
refer
my video: https://youtu.be/CuczXPj0N-k
or
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualizationAnonymous , you need a measure slicer to shift the measure, you need a filter on the values of the slicer?
measure slicer means choosing a measure to display on visual.
These are options
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYMEIn case you filter on measures like the value of saving between 1-100 etc. then it what I posted last. If you want I can try that on this file.