topic Re: dynamic title from calculation group selection in DAX Commands and Tips

dynamic title from calculation group selection

wenchi — Tue, 09 Feb 2021 20:29:43 GMT

my report connect to AS model using live connection. The AS model contains few calculation groups including time intelligence and measure metric, such as volume, store count, etc. They all work as expected. I am trying to create a dynamic chart tiltle based on the item the user pick from calculation group. For example, if the user choose volume, the title will show "YoY Volume Comparsion" or "YoY Store Count Comparison" if the user choose store count from calculation group. I can't find a way to get the the selected item from calculation group. I've tried selectedvalue or isfilter dax, and none of them work. Any one get this to work ?

Another related question to calculation group is how to create a measure that can ignore the calculation group? I use ALL in my dax code, and it does not work either. Sometimes I need to display data in a table and not all measures in this table that i want to work with calculation group and I can't find a way to solve it either.

Any helps is appreciated.

thanks,

Wenchi Wang

Re: dynamic title from calculation group selection

amitchandak — Wed, 10 Feb 2021 02:45:40 GMT

wenchi , Not very clear. Have you used Tabular Editor?

https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

https://www.youtube.com/watch?v=vlnx7QUVYME

Re: dynamic title from calculation group selection

wenchi — Wed, 10 Feb 2021 12:52:32 GMT

I create the AS model using Visual Studio which had calc group. No issue for calculation group. Just wondering how to get the selected item and incorporated to visual title in PBI report. For example, my time table has MTD, QTD, YTD calculated items. How do I detect which item selected by the user?

Re: dynamic title from calculation group selection

Anonymous — Tue, 27 Jul 2021 14:25:10 GMT

wenchi ,did you get any solution? I'm too looking to implement the dynamic title.

SELECTEDMEASURENAME() and SELECTEDVALUE() did not work for me either.