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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Phoen1x09
Frequent Visitor

Conditional Formatting more than 1 visual per Page? Not possible?

Edit: Found a solution. I had 3 variables set to my Y axis. I had to remove the other two until I had just the one variable and then I was able to set the conditional formatting on the 2nd visual, and then I added back in the other variables on Y. 

 

Hello,


I have a few line charts that arebeing developed for SPC and I would like to have conditional formatting for the data labels for each.

 

For the first visual, I was able to go to the Data Labels format section and click the FX button next to color, no problem.

I then made another line chart visual, but the FX option just isn't there! 

Is it not possibel to have more than one conditional format setup? I'm confused about why it works for one but not the other. They are drawing from the same data table. The only difference is that for the Y-axis value of the 2nd chart I am using a measure to filter out some duplicate IDs. 

As an example of what I mean. The data in the table could be a record of how much a person weighs and would have data on some people more than once (say last week and this week or w/e), and the measure is filtering that for the second chart so that it only shows the most recent weigh-in per person.

Is the measure the problem?

I also tried just duplicating the table and transforming it in Power Query Editor to meet the same purpose. But still no conditional available on anything but the first line chart on that page.

1 ACCEPTED SOLUTION

Found a solution! I had 3 variables set to my Y axis. I had to remove the other two until I had just the one variable and then I was able to set the conditional formatting on the 2nd visual, and then I added back in the other variables on Y. 

View solution in original post

4 REPLIES 4
Awm
Frequent Visitor

Try format painting from the first visual to the second one. Its a quick solution. But both the good one

Anand24
Super User
Super User

Hi @Phoen1x09 ,
Ideally, you should be able to conditionally format as much visuals as you want in a page. Trying clearing out the cache once and retry after reopening the report.

Also, what are you taking in the X, Y and Y2 axes of line charts?

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

I'm using Date(time) for X.

Measured variable for Y. (weight in the example)
Also have threshold lines on Y (average, pass, st dev)

Nothing on Y2 atm.

 

Tried clearing the cache and reopening like you suggested, but it didn't work. Still just no option for the second line chart.

Phoen1x09_0-1698357781594.png


But still conditioned for the first:

Phoen1x09_1-1698357883002.png

 

Found a solution! I had 3 variables set to my Y axis. I had to remove the other two until I had just the one variable and then I was able to set the conditional formatting on the 2nd visual, and then I added back in the other variables on Y. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors