Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

0

Water fall Chart Caltegory Colour isssue

Hi Team, In traditional water fall chart ,we are not able to give different colours for X-axis category .The colours will be given for rise up ,rise down and a total field. We are facing mainly 2 limitations It is not possible to give different colour for different category how to remove the total field from the water fall visual How to overcome the above things Please help on this Regards Arjun V
Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

Based on my research, it''s not supported to do it currently. For your requirements, please vote these two same ideas up: 

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17692234-waterfall-chart-improvement-color-changing-for-sta

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9910269-capability-to-show-hide-total-column-in-waterfall

 

Best Regards,
Qiuyun Yu

v-qiuyu-msft
Community Support
Status changed to: Delivered
 
Anonymous
Not applicable

HI Team This issue have been implimented by using R scrip. Steps to follow : Install
Enable R visuals
Select the R Visual icon in the Visualization pane,
When you add an R visual to a report, Power BI Desktop does the following:
A placeholder R visual image appears on the report canvas.
The R script editor appears along the bottom of the centre pane
Next, add fields you want to consume in your R script to the Values section in the Fields well, just as you would with any other Power BI Desktop visual.
When the script is complete, select Run from the R script editor title bar (Run is on the right side of the title bar).

Expected visual will be generted

 

Picture1.png