Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to Solution.
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.
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.
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.
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.
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!
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |