The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello everyone, I need some help.
I want to add a bar graph inside a column of a Matrix visual. Is this possible?
As shown in the sample image below, I want to apply colors to the bars in the graph.
Sample image
I need to replicate the same style as shown in the sample image.
Hi @Chari
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
Hi @Chari
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
Hi @Chari ,
Thanks for reaching out to the Microsoft fabric community forum.
Yes, it’s possible to add a bar-like visualization inside a column of a Matrix visual in Power BI by using data bars through conditional formatting. To do this, first select your Matrix or Table visual, then locate the field in the Values area of the Visualizations pane. Click the dropdown arrow beside the field name and choose Conditional Formatting, followed by Data Bars. In the formatting options that appear, enable data bars and customize them as needed for example, by adjusting minimum and maximum values or changing the bar colour.
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi @v-nmadadi-msft ,Thanks for your reply.
We can add bars in Matrix or Table visuals, but we can't apply conditions like the ones below. We can only show positive and negative values.
Hi @Chari ,
Thanks for reaching out to the Microsoft fabric community forum.
Go to Conditional Formatting and then click on background color
change the format style to Rule based, over here you will be able to give the rule based colours that you require.
you can modify your rules like the screenshot shared below.
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi @Chari
Have you tried using Sparklines? They allow columns charts:
https://www.wiseowl.co.uk/power-bi/blogs/power-bi-desktop/power-bi-updates/sparklines/
If not it is possible to use SVG images to create this:
https://www.youtube.com/watch?v=QOcP5OvSwlI
https://darren.gosbell.com/2019/11/building-custom-data-bars-in-power-bi-using-svg-measures/
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.