Forum Discussion
How to add bar graph in Matrix visual.
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 Anonymous ,
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
7 Replies
Hi Anonymous
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/Hi Anonymous ,
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 youHi 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 Anonymous ,
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 Anonymous
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 Anonymous
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank youHi Anonymous
As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.
Thanks and regards
