Forum Discussion

AbdulAzad's avatar
AbdulAzad
Frequent Visitor
7 years ago
Solved

Dynamically Add or Remove Dimension or attributes to a table visual using a slicer selection

Hi, I am pretty new to Power BI, I wanted to show and hide columns in a table visual based on slicer selection, columns are like Effective_Date, Purchase_Date, Quantity, Order_Number. How can I achiev...
Need Help
  • AbdulAzad's avatar
    AbdulAzad
    7 years ago

    Hi Jimmy,

     

    It didn't solve to the extent I expected, because I wanted even dimensions to be shown and hidden based on slicer selection, the solution provided will not work, if I try to pivot my table on huge volumes of data. Where I used the DAX expressions to hide and display only measures not the dimensions at this point of time.

     

    Thanks & Regards,

    Abdul

AbdulAzad's avatar
AbdulAzad
Frequent Visitor
7 years ago
Hi Vamsi, Thank you very much for you reply. For my requirement this approach doesn't fit, because my data volume is huge on top of it I have to duplicate the queries and do pivot. I have replied my detailed requirement in the same post. If you have some other approach which fits my requirement that will be much appreciated. Thanks & Regards, A