Need a break point to adjust the numbers to overall in "Clustered Column Chart"

[harirao]

Hi,

I want to create a break point to adjust the numbers to overall in "Clustered Column Chart", when every count is >=55 (measure).
and small bar with count 1, 2 should look little bigger.

Below Chart for reference.

I have to create chart, as per below example:


Regards,

Hari

[v-juanli-msft]

Hi @harirao 

As tested, i don't find any break point in Power Bi, you could use a workaround below:

Create a measure 

Measure = IF(SUM('Table'[value])>=55,55)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[harirao]

Hi @v-juanli-msft, 

Thanks for your help, and providing update on Break Point option is not available in Power BI.

Please note i have calculated dax measure for count,

Count = CALCULATE(DISTINCTCOUNT(Sheet1[OpportunityId]), FILTER(Sheet1, Sheet1[actual_visibility_weeks]>= 1)) + CALCULATE(DISTINCTCOUNT(Sheet1[OpportunityId]), FILTER(Sheet1, Sheet1[actual_visibility_weeks]= 0))


Can you help me how to implement this measure provided  (Measure = IF(SUM('Table'[value])>=55,55) in my dax.

Thank you

Regards,
Hari

[v-juanli-msft]

Hi @harirao 

Just use:

IF([count]>=55,55)

Best Regards

Maggie

[harirao]

Hi @v-juanli-msft  
Can you please help me on this DAX calculation.

Regards,

Hari 

[harirao]

Hi @v-juanli-msft 
Can you please help me on this DAX calculation.

Regards,

Hari 

[amitchandak · Accepted solution]

@harirao , Choose scale Type =log .  Under Y-axis property

[harirao]

Hi @amitchandak,
Thanks for your response, changed Scale Type to log, Let me know how can i provide break point "55" for this Chart?

Regards,

Hari