Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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.
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
bump
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |