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
Solved! Go to Solution.
@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.
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%
@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 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 , 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|
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.