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|
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.