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 c...
Need Help
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

MilanRao06's avatar
MilanRao06
Advocate I
9 years ago

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.