Forum Discussion

MilanRao06's avatar
MilanRao06
Advocate I
9 years ago

Dynamic calculated column/table based on Slicer selection

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
  Zone1Zone2Zone3
Q3Zone14345
Zone24121
Zone34717

 

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

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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