Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 data
Power BI graph-Jan 2018 to Dec 2019 data
These 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
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |