Forum Discussion
Helper IITable visual with Slicer
Hi All,
I need to create Table visual in Power BI with Slicer for each column. The data should be calculated based on the selection from dropdown. The values in the dropdown are measures.
Thanks,
Arul
Aruljoy , check for measure slicer or calculation group
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
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-patterncalculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
2 Replies
- amitchandak
Super User
Aruljoy , check for measure slicer or calculation group
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
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-patterncalculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/ - v-luwang-msft
Community Support
Hi Aruljoy ,
According to the official article, the slicer can act on the whole page, on other pages through Sync slicers, or through
to control which page visuals are affected by slicers，but in my opinion, the lowest level of the slicer's usefulness is the visual effect, not the column, so it is not possible to configure the slicer to show different results per column.When you use slicer ,at least filter a visual.
refer the following ideas
Multi-Columns Slicer
AND Slicer - OR Slicer - Measure SlicerDid I answer your question? Mark my post as a solution!
Best RegardsLucien
