I have a table visual with columns created by measures. I want to make it possible to hide the columns that I don't need (i.e. choose the columns I want to appear).
I was thinking of creating a slicer visual with values similar to the column headers in the said table visual, but failed to achieve anything due to the fact that the measures and the additional query for the slicer are not linked (via relationship).
Looking forward to your expert advice on achieving this! (Note: at the end, I want the user of the report to have the option to choose the columns that person needs via the slicer visual. The user will be using the PBi web app).
Thank you!