Need Help

[DanduMani104]

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

[Anonymous]

Hi @DanduMani104 ,

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

[DanduMani104]

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

[Anonymous]

Hi @DanduMani104 ,

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