topic Re: Need Help in Developer

Need Help

Anonymous — Wed, 17 Jan 2024 10:59:01 GMT

I have a Excel visual like below

In this there is Percentage is also there for every bar...at the same time in my power bi

visual is like this....How can I made my power bi visual like excel visual

Re: Need Help

Anonymous — Thu, 18 Jan 2024 03:31:58 GMT

Hi @Anonymous ,

Thanks for reaching out to us with your requirement. Base on your provided screenshots, you are trying to create a similar column chart with difference percentage in Power BI with the one in Excel. I didn't find a direct method to get it in Power BI. However, you can follow the steps below by using tooltips as a workaround.

1. Create a measure to get the percentage

Difference percentage= VAR _lightblue = CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[category] = "A" ) VAR _darkblue = CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[category] = "B" ) RETURN DIVIDE ( _lightblue - _darkblue, _lightblue )

2. Select your column chart and add the measure onto the Tooltips option

Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

Best Regards

Re: Need Help

Anonymous — Thu, 18 Jan 2024 06:11:51 GMT

I want to show the increase and decreases in percentage..Like it shows in Excel

Re: Need Help

Anonymous — Thu, 18 Jan 2024 08:25:40 GMT

Hi @Anonymous ,

Could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with special examples and screenshots? Later I will check if there is any workaround to achieve the similar requirement. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards