Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
ClaytonLFA
Frequent Visitor

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?

ClaytonLFA_0-1742415623325.png

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.

ClaytonLFA_1-1742415811964.png

 

1 ACCEPTED 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.

View solution in original post

5 REPLIES 5
lbendlin
Super User
Super User

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!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.