Cumulative bar chart for categorical varibale

[LaurieK]

Hi there.

I'm trying to generate a cumulative bar chart on a categorical time based variable. So as can be seen below I have produced the percentages for each timeframe category, but would like to have <28 days as 87%, <60 days as 87+10 = 97%, and <90 as 100%.

Is there a simple way to do this with the chart options or do I need to create a new variable. If the latter, could someone steer me in the right direction for the dax code? (I am a dax newbie)

Thanks in adavance

[amitchandak]

@LaurieK , Not enough information.

You have to try like

Cumm = CALCULATE([Measure],filter(allselected(Table),table[bucket] <=table(Sales[bucket])))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[LaurieK]

Hi again @amitchandak 

Sorry, I am unsure how to add a file here. I tried a drag and drop of .pbix file and it didn't work.

I've had to resort to pasting screengrabs of some dummy data, and the subsequent Power BI visual. Hope that makes sense.

So I need the above figures to read cumulative, ie 52.17%, 82.6%, 100%

Thanks

[amitchandak]

@LaurieK , If days to close is a column , try

Cumm = CALCULATE([Measure],filter(allselected(Table),table[days to close] <=max(Table[days to close])))

The measure is your % column

[amitchandak · Accepted solution]

@LaurieK ,

Please find the solution file attached after the signature. Leave my last update.

I have created one measure where you can you the option you shown in the last update

[LaurieK]

@amitchandak  thank you so much for this. That is perfect!

[LaurieK]

@amitchandak  Thanks for that..  I didn't actually create a percentage measure, rather just used the visual to calculate that

I'll try to add as a measure and see how that goes. 

[amitchandak]

@LaurieK , You upload to onedrive and dropbox and share.

or copy paste table from Power BI

[LaurieK]

@amitchandak , here you go.. Learning as I go 🙂 

RecordDays to closeDays to close cat

1	25	Less than 28
2	16	Less than 28
3	28	29 to 59
4	52	29 to 59
5	2	Less than 28
6	15	Less than 28
7	13	Less than 28
8	7	Less than 28
9	29	29 to 59
10	6	Less than 28
11	12	Less than 28
12	27	Less than 28
13	7	Less than 28
14	50	29 to 59
15	55	29 to 59
16	2	Less than 28
17	55	29 to 59
18	56	29 to 59
19	89	60 to 89
20	71	60 to 89
21	84	60 to 89
22	7	Less than 28
23	66	60 to 89