Issue with Stacked Bar-multiple fields

Anonymous · ‎01-16-2020

Hello All,

Hope you are doing good!

Facing an issue with stacked bar. Please refer below 2 screenshots of Excel graph and Power BI graph respectively to understand the issue.

We have 13 fields in stack bar.Data is for 2 years-Jan 2018 to Dec 2019

Unable to get slope like a structure for all months in Power BI graph, which is present in Excel Dashboard

The “current value” field for Jan 2018 (Blue colour) is “Before_1_Month” field for Feb 2018,"Before_2_month" field for March 2018 and they are giving it same colour throughout for that value. Same for Feb 2018-current month is red and so on. However in Power BI I have added those 13 fields/columns in data colours because of which slope structure can’t be seen.

Below are screenshots of Graph already present in excel dashboard, graph created in Power BI and the 13 columns which we are using.

The data is correct but the arrangement of fields and color seems difficult.

Can you suggest how to achieve this.

I can be reachable at rajat.f.jain@capgemini.com or rajat.jain@wolterskluwer.com

Please suggest.

Excel Graph-Jan 2018 to Oct 2019 dataPower BI graph-Jan 2018 to Dec 2019 dataThese are the 13 fields-current month, before 1 month, before 2 month etc fields and i have added them in data colors so they giving same color