Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to make a column chart with measure as the value to have conditional formatting? This is how it is now.
Thanks.
Solved! Go to Solution.
If you have something in the legend field, you cannot use formatting.
However, I think from the picture, that you do not have anything in the axis field of your column chart.
Please put something in the axis, and check again. It can be a disassociated table with a single value if really needed. When applying custom formatting, make sure you hover your mouse over the ellipsis to make it show.
Otherwise, I suggest if you are only displaying one value, you could use a CARD visual, and format the background using the same conditional formatting found in background attributes.
If you want to show the target other options could be a KPI, GUAGE, or the custom visual CARD WITH STATES by sqlbi.
Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!
Stay up to date on
Read my blogs on
Remember to spread knowledge in the community when you can!
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
If you have something in the legend field, you cannot use formatting.
However, I think from the picture, that you do not have anything in the axis field of your column chart.
Please put something in the axis, and check again. It can be a disassociated table with a single value if really needed. When applying custom formatting, make sure you hover your mouse over the ellipsis to make it show.
Otherwise, I suggest if you are only displaying one value, you could use a CARD visual, and format the background using the same conditional formatting found in background attributes.
If you want to show the target other options could be a KPI, GUAGE, or the custom visual CARD WITH STATES by sqlbi.
Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!
Stay up to date on
Read my blogs on
Remember to spread knowledge in the community when you can!
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
@Anonymous Did you tried this way ? If not, please do and post any questions.
Proud to be a PBI Community Champion
Infortunately I am not getting a conditional formatting button. This is how it looks like for me
@Anonymous There will be a small ellipse button on the right side as shown below (it looks like hidden, may be due to the light background as well)
Proud to be a PBI Community Champion
Unfortunately I do not have the button. I clicked near that area many times to see if there is one but there isn't. Is there another way?
Proud to be a PBI Community Champion
@Anonymous Here is another screenshot which might help you...
Proud to be a PBI Community Champion
@PattemManohar I looked in data colours but there is no button. What would be another solution?
@PattemManohar wrote:@Anonymous Here is another screenshot which might help you...
@Anonymous If you can't see the conditional formatting (not sure why you are not able to see that option, hopefully you have the updated PBI Desktop version) then you can't have dynamic colouring for your column bars. But if you want to change to some other colour (which will be static) then you can easily do (but that is not a feasible solution). I strongly suggest you to find why you are not able to see that feature.... Also, enable all the preview features in the options and settings of PBI Desktop.... Try all the way !
Proud to be a PBI Community Champion
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |