Forum Discussion
Dynamic Column on slicer selection
Hey,
what you are looking for is a solution that takes the benefits from an unrelated table. What you need is a table that just contains the branches "Branch 1", "Branch 2", ...
Then you can use table as content for a slicer and also as column header for a matrix visual. What you have to do, is writing a measure that maps the value (Branch 1 with the date value) from your table to the content of the axis coming from the unrelated table.
In this post I describe an approach how to use unrelated tables:
If you provide sample data, ideally in form of a pbix file (share the link to this file using onedrive or dropbox), we can provide a solution or guide you further.
Regards
Hey,
what you are looking for is a solution that takes the benefits from an unrelated table. What you need is a table that just contains the branches "Branch 1", "Branch 2", ...
Then you can use table as content for a slicer and also as column header for a matrix visual. What you have to do, is writing a measure that maps the value (Branch 1 with the date value) from your table to the content of the axis coming from the unrelated table.
In this post I describe an approach how to use unrelated tables:
If you provide sample data, ideally in form of a pbix file (share the link to this file using onedrive or dropbox), we can provide a solution or guide you further.
Regards