Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to 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.
Try format painting from the first visual to the second one. Its a quick solution. But both the good one
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?
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 !!! |
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.
But still conditioned for the first:
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.