Forum Discussion
100% stacked column chart
Hi Community,
Kindly find my questions bellow and screenshots for your reference and please help me out to reach my requirements.
I am using 100% stacked column chart with small multiples option which will be deviding into visual into four parts as shown in the below image.
Requirement:
this i want to implement in power bi.
Pic - 1
Below pic is what i have implemented in Power BI till
Pic - 2
Requirement in Details.
1.Place the timeframe in sequence on x axis - (oct 23,nov 23,dec 23,jan 24,feb 24, mar 24)
2.Adjust sequence of responses on bars (should be agree,neutral,disagree, Not Assessed)
3.Show EE and PFH above timeframe on x axis (refer pic-1)
4.Show count of abv_cust_id below each graph (refer pic -1)
Kindly show and tell.
and please let me know if it is possible or not.
5 Replies
Hi Anonymous ,
Based on your description and the illustration provided, the first step in ensuring that the time ranges (e.g., October 23, November 23, etc.) are displayed in the correct order on the x-axis is to ensure that the data model either recognizes the time ranges as date values or sorts them in a customized order; Power BI automatically sorts the date values in chronological order. If the time range is not recognized as a date value, you may need to create a custom column in the data model that Power BI can recognize as a date or manually specify the order using the Sort by Column feature.
Secondly if you want to sort the legend you can do so by changing the order of the fields in the X or Y axis data filed.
Third, if you want to display PE and EE, you can place both fields on the x-axis.
Finally, to display the counts you can use the cards to display them
I hope this helps you, for more information about x-axis sorting you can refer to this content
Sort one column by another column in Power BI - Power BI | Microsoft LearnBest regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous
Thanks for the quick reply.
1st solution i tried and it got resolved.
2nd solution i am not able to do, i will be sharing the screenshots for your reference.
3rd soluton , i have already did the same but it is not showing how i want.
4th solution will be not feasible beacuse i am using small multiple option which will be dividing visual into multiple parts and beacause of that the visula will be not constant in size.
screenshort for your reference.
1.
2.
3.
Hi Anonymous ,
Thank you for your reply, since we can't tell the structure of your data and the composition of your charts, we need you to provide the pbix file, please hide the sensitive information in advance so that we can help you faster.Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly