Table visual with Slicer

[Aruljoy]

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

[v-luwang-msft]

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 Slicer

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[amitchandak · Accepted solution]

@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/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/