Dynamic calculated column/table based on Slicer selection

[MilanRao06]

Hi Community,

I have been raking up my brains over the below use case for a couple of days now and don't seem to find a way out. Appreciate any help,

I am building a report for my quarterly customer satisfaction. I have a page in my report which shows the details of the satisfaction scores for common respondents in two consecutive quarters. Each response is categorized in three zones - Zone1, Zone2, Zone3 - based on the satisfaction score. I want to display a matrix as below where the columns are the count of common respondents in each zone in the previous quarter and the rows represent the same for the current quarter.

		Q2
		Zone1	Zone2	Zone3
Q3	Zone1	43	4	5
Zone2	4	12	1
Zone3	4	7	17

I want to display the list of customers in another table below this matrix. I want to add a slicer for the quarters. If the user selects Q4, it should show the same table for Q4 (in rows) and Q3 (in cols).

Thanks,

Milan

[v-shex-msft]

Hi @MilanRao06,

Power bi not support create the dynamic calculate table/column based on slicer.  Slicer works on visual level, it can't effect calculate column/table which based on source data. In summary, calculate column/table has Pretreatmented before selected on slicer, current you can only create a dynamic measure based on slicer.

If you want create a dynamic table, you can try to use parameterized query.

Deep Dive into Query Parameters and Power BI Templates

Regards,

Xiaoxin Sheng

[MilanRao06]

Using parameters won't help because I would have to save the file as a PowerBI template (.pbit). I want to publish the report to the service so that employees in my organization can consume the report.

[v-shex-msft]

Hi @MilanRao06,

I'd like to suggest you take a look at dynamic RLS, it may suitable for your requirement:

Power BI – Dynamic Row Level Security – Tips to get it working!

Regards,

Xiaoxin Sheng

[MilanRao06]

bump