Generate table visual dynamically by selecting measures and dimensions from slicers

[rob_vander]

Hi All,

I have requirement where I need to populate table visual dynamically based on selections from slicers. Basically I need to show two slicers 1) Dimensions 2) Measures. DImension slicers contains the list of dimensions for eg. Year, Area, County etc. Measure slicers contains the list of measures for eg. Sales, Volumes, Cost etc.

I want that if user selects a particular dimension and measure from both slicers, table visual should populate with that dimension and measure. User can select multiple dimensions and measures from slicers. If there is no selections from both slicers report should be blank with message that "Please select a dimension and measure to view this report"

[rob_vander]

@Jihwan_Kim  Thanks for the reply. Problem is that Card visual layered at top not allowing click on table cell for filtering. Is there way to select cell value from table visual?

[Jihwan_Kim]

Hi, 

One of ways to achieve this is using Field Parameter feature.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Please check the above link and the below sample pbix file.

I tried to create a sample pbix file like below, and I hope the below can provide some ideas on how to create a solution for your datamodel.