Forum Discussion
Conditional Formatting Subtitle - Measure not updating via visual interaction
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.
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.
5 Replies
- lbendlin
Super User
I am trying to make a line chart visualization that reports the value in the subtitleWhich value? A line chart by definition has multiple values.
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.
- lbendlin
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.
