topic Generate table visual dynamically by selecting measures and dimensions from slicers in DAX Commands and Tips

Generate table visual dynamically by selecting measures and dimensions from slicers

Anonymous — Sun, 30 Jul 2023 22:55:34 GMT

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"

Re: Generate table visual dynamically by selecting measures and dimensions from slicers

Jihwan_Kim — Mon, 31 Jul 2023 04:34:29 GMT

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.

Re: Generate table visual dynamically by selecting measures and dimensions from slicers

Anonymous — Tue, 01 Aug 2023 10:19:34 GMT

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?