Forum Discussion
BAR CHART
Dear all ,
I have made 6 measures which calculates percentage of a field my customer desire.
Now the problem is I want this to be plotted on bar graph .
Which is done nicely
But as there is no values on x axis hence the bars are Sticked very close to each other .
Is there any way to do padding between them ???
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 😁
9 Replies
Sujit_Thakur , I checked, there is an option for padding. But that does not give a gap between Measures(M1 nad M2).
Dear @amitchandak sir,
I have data of boxes and its weights.
I have calculated measures for
<75% , 75-85, and so on till >125%.
Now when I use this measures in bar chart .
They get closely stuck .
Can you please suggest some post /blog/video on makeing bins/category for barchart using values from measures
So that instead of adding measures to field of barchart . I will use my bins
Sujit_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/
Hi Sujit_Thakur
You can check x-axis options:
But please send an example and it will be easier to say something.
_______________
If I helped, please accept the solution and give kudos! 😀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 😁
