Forum Discussion
dynamic dimension
Hi Emmy66,
Tom provides a cool workaround for this problem. Another alternative is to use bookmarks to create different views of the page, where you display different tables based on your selected bookmark. Essentially this means placing a different copy of the table in each bookmark with the categories you want to display, whilst hiding the "unused" tables. You can then toggle which bookmark to display through for example a button with an action.
It can be a little fiddly to set up but it's quite straight forward. This video is a few years old but the process is pretty much the same:
https://www.youtube.com/watch?v=_Afcj8mT5_Q&feature=emb_logo
Hope this also sheds some light on potential solutions!
Thanks Anonymous for your suggestion. Much appreciated. Though the link was very helpful but it's not exactly what I wanted.
Hi Emmy66
In addition to TomMartens 's reply, I think you can use a measure to filter your data table.
Due to I don't know about your data table, I build a sample to have a test.
Sample Table:
Metric Selection table:
Measures:
Metric Selected = SELECTEDVALUE('Metric Selection'[Metric],"Country")Filter = SWITCH(TRUE(),MAX('Table'[Category])='Metric Selection'[Metric Selected],1,0)Build a table visual, add Filter Measure into Filter Field and set it show items when value =1.
It will show country by default.
If you select Department:
If this reply still couldn't help you solve your problem, please show me your data table and more details about your requirement.
You can download the pbix file from this link: File
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , thanks alot for your proposed solution. As I mentioned in my reply to TomMartens , I've recreated the table with the 1st 2 columns but stock with how to get the measures in. Any further details on how to go about it will be highly appreciated.
