topic Re: Conditional Formatting Subtitle - Measure not updating via visual interaction in DAX Commands and Tips

Conditional Formatting Subtitle - Measure not updating via visual interaction

ClaytonLFA — Wed, 19 Mar 2025 20:24:21 GMT

Hello, I am trying to make a line chart visualization that reports the value in the subtitle. I have tried several different DAX formulas but none of them provide a real-time update when the visual is interacted with. They work seperately as their own visualizations.

Is this a limitation of the program or can this functionality be achieved by modifying the DAX or some other setting?

ChartSubtitle = CONVERT(FORMAT(IF(HASONEVALUE(data[Sum of Closed Order]),VALUES(data[Sum of Closed Order]),SUM(data[Sum of Closed Order])), "#,##0"),STRING) // SelectedOrders = VAR SelectedOrder = SELECTEDVALUE(data[Month]) RETURN IF( NOT ISBLANK(SelectedOrder), CONVERT(FORMAT(CALCULATE(SUM(data[Sum of Closed Order]), data[Month] = SelectedOrder), "#,##0"),STRING), CONVERT(FORMAT(SUM(data[Sum of Closed Order]), "#,##0"),STRING) ) // SelectedOrderSum = CONVERT(SELECTEDVALUE(data[Sum of Closed Order],data[SelectedOrders]),STRING)

As you can see all of these formulas produce the expected visual interaction when the measure is placed in a seperate visual but do not update when used as the conditional formating measure.

Re: Conditional Formatting Subtitle - Measure not updating via visual interaction

lbendlin — Wed, 19 Mar 2025 23:47:01 GMT

I am trying to make a line chart visualization that reports the value in the subtitle

Which value? A line chart by definition has multiple values.

Re: Conditional Formatting Subtitle - Measure not updating via visual interaction

ClaytonLFA — Thu, 20 Mar 2025 15:01:13 GMT

Hello, the subtitle is supposed to be a dynamic field that changes as you click an individual point on the line chart. You can see I have clicked the second data point on the line chart and the visual interaction is working with all 3 measures if they are in their own visualizations, however, it does not actually update the in the subtitle.

Re: Conditional Formatting Subtitle - Measure not updating via visual interaction

lbendlin — Thu, 20 Mar 2025 19:28:58 GMT

Looks like the SELECTEDVALUE paradigm does not extend to the line chart visual. Switching to a column chart doesn't help either as it then no longer shows the title or subtitle.

I would suggest you raise a ticket.

Re: Conditional Formatting Subtitle - Measure not updating via visual interaction

v-aatheeque — Thu, 08 May 2025 17:55:40 GMT

Hi ClaytonLFA ,

Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

Re: Conditional Formatting Subtitle - Measure not updating via visual interaction

v-aatheeque — Sun, 18 May 2025 17:57:41 GMT

Hi ClaytonLFA ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!