Forum Discussion
Dynamic column in matrix visual
Hey all, I need to have dynamic columns in matrix visual. i have few columns in my tables(different tables) . i want these columns as options in slicer. when i select particular slicer that column s...
Mariusz
Community Champion
Community ChampionHi Anonymous
I probably would suggest using either Paginated Reports or Combination of Bookmarks and Buttons to show/hide the columns in the matrix,
I head a go at it using DAX and the result is on the attached.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz what you mean by paginated reports?
- Mariusz
Hi Anonymous
Please see the link, essentially its bringing SSRS reports to Power BI, however premium capacity is needed for that.
https://docs.microsoft.com/en-us/power-bi/paginated-reports-report-builder-power-bi
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.Mariusz Thanks so much . I had gone through your pbix. Can you please what your dax is doing over there.i mean its main functionality?