Forum Discussion
Solution SageBAR CHART
Dear all ,
Instead of measure
I created a calculated column of overload which shows group <25, >50 and so on
And created a table with one column which had <25 and such other groups of percentage
Then I gave a relationship between them .
And ta da .
It's done 😁
Super UserSujit_Thakur , For segmentation you refer to my video. Bucket on Margin %
These are other links
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bins
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-in-power-bi/
Solution Sage- Sujit_Thakur
Dear @amitchandak
Is there any way of doing following.
Please help
I have 6 measures which calculates percent overload .
Now how should I create a calculated column(as measures can not be added in axis) so that I have category of percentages
Like
As now it doesn't have a x axis so it shows all bar chart sticked to each other .
But if I had some category to put on x axis then it would have differentiated on x axis
That
<25%
25-30%
And so on
- amitchandak
Sujit_Thakur ,Can you share sample data and sample output format? Or a sample pbix after removing sensitive data.
- Ashish_Mathur
Hi,
Share some data and show the expected result in a simple table format.
