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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Issue with Stacked Bar-multiple fields

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 dataExcel Graph-Jan 2018 to Oct 2019 dataPower BI graph-Jan 2018 to Dec 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 colorThese 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

Thanks,

Rajat

Email: rajat.f.jain@capgemini.com or rajat.jain@wolterskluwer.com

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.