% graph by month

[Anonymous]

Hello Power BI community,

There is a data that I am working with , one of the column has value  <1.33 or >1.33

The count graph looks like this,

But target graph is percentage of >1.33 and <1.33 by month. When I try using GT% it gives % of a ummulative but not by month.

Can I please get help on how to get the % by month?

Thank You,

Rushi Sathi

[amitchandak]

@Anonymous , I did not get it completely , See if this can help

https://radacad.com/showing-the-total-value-in-stacked-column-chart-in-power-bi

[Anonymous]

Hello @amitchandak :

Thanks for the reply. But that is not what I am looking for.

Let me explain it with a simple example: 

Let there be a data table with a column "Result" saying yes or no. 

Whn I plot a graph with the column value "Count of Result", with the X-axis as month, then I get a graph showing how many "yes" and how many "no" per month. 

What I want is % instead of count, for example: January has 10 "yes" and 10 "no", the graph should say 50% "yes" , 50% "no". 

As per my understanding, we need a measure to do this,

I am just getting started with power bi, so not so sure how to do this.

Thanks in advance,

Rushi Sathi

[ryan_mayu]

@Anonymous 

Try this measure and put measure in the value field.

% = sum('Table'[value])/CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[month]))

Hope this is helpful.

[Anonymous]

Hello @ryan_mayu :

You are so close. 

The way I have the data is a little different 

Can you please tell me how to do it with the data like this?

Thank you in advance,

Rushi Sathi

[ryan_mayu · Accepted solution]

@Anonymous 

I assume you have the calendar table and build relationship with the tale you shared.

Measure = 
VAR _count=COUNTROWS('Table')
VAR _count2= CALCULATE(COUNTROWS('Table'),ALLEXCEPT(datetime,datetime[month]))
return _count/_count2

[amitchandak]

@Anonymous , I doubt that is possible. Check on any idea for that and vote or create a new idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32082391-totals-in-stacked-column-charts