Forum Discussion
Expression based titles based on drill down
Hi There,
I am trying to create an expression based title in Power BI Desktop, based on drill down.
In the example above, title card should show Title 1, and when drilled down in the visual change to Title 2.
Maybe someone has any advice on how to do that?
Thanks in advance!
Hi Dom87326
Do you mean changing the title of the visual? If so, I think it is not possible.
I tested both ISFILTERED and ISINSCOPE. When used for the title, it can be affected by slicers and filters outside. But it cannot be affected by the drill down status of its own visual.
Also, when you pick a data point in the visual, it can filter or highlight other viusals on the same page. But when you only drill down, it cannot. Drilldown is not filter so it cannot pass any filter context to other visuals or formulas.
Overall, I think it is not possible to create a dynamic title based on drill down.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
3 Replies
Dom87326 , Check for isfiltered or isinscope in a measure if those can help
Hi Dom87326
Do you mean changing the title of the visual? If so, I think it is not possible.
I tested both ISFILTERED and ISINSCOPE. When used for the title, it can be affected by slicers and filters outside. But it cannot be affected by the drill down status of its own visual.
Also, when you pick a data point in the visual, it can filter or highlight other viusals on the same page. But when you only drill down, it cannot. Drilldown is not filter so it cannot pass any filter context to other visuals or formulas.
Overall, I think it is not possible to create a dynamic title based on drill down.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.I have a matrix visual with 3 fields in the Rows section, say RowField1, RowField2, and RowField3. By default, the visual only displays the first field name as the "column label" for the row headers. Is there a way to put into a measure the concatenated row field names so that I can use it as part of the visual's title? The idea is to make it dynamic so that if the user personalizes the visual and added a 4th row field, it will show in the concatenated field list in the title. Something like RowField1/RowField2/RowField3, then RowField1/RowField2/RowField3/RowField4 when a 4th field is added by the user.
