Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I want to format my chart in two colours, red and green.
In one column there are three options to select. For the options cXML and Online is a positive bar in green needed, and red if the percentage is negative. For the paperinvoice it is the opposite. Green bar if the percentage is negative and red if the bar is positive.
How do i fix this?
Graph
Sort
Hello,
I cant share the PBI file, because it contains copmany data. I have made an Excel file, with random data.
One measure is needed what the difference is between the quarters for each method how many invoices there are. For cXML and Online it have to be red if the percentage is negative and green if it is positive. If the Paperinvoice percentage is negative it must be green and if the percentage is positive it must be red. I hope you have enough information.
The difference have for each quarter needs to be in a bar chart
https://we.tl/t-JI9YFqhada
Hi Matthijs,
There are two ways to solve this issue. Click on your graph and select the format option on the right side of your screen. You could set rules for data labels by clicking on the (fx) button. Change the format style to rules and choose the appropriate field on which you would like to base your rules.
Hence you could say if < 0 percent then (color) red etc...
Follow this link for more help: https://community.powerbi.com/t5/Desktop/Conditionally-format-bar-chart-column-colour-based-on-slice...
Adjusting this slightly will help solving your issues.
Goodluck
This is not the right answer. I have three options:
In one column there are three options to select. For the options cXML and Online is a positive bar in green needed, and red if the percentage is negative. For the paperinvoice it is the opposite. Green bar if the percentage is negative and red if the bar is positive.
The graph has a dynamic title
Initially I misunderstood your question. If you could share your pbix file, I can help you out with this.
I just have to try a few DAX to solve it.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |