Waterfall chart. Show latest value. SSAS cube Live Connection

[Mapei_Henrik]

I need to show the total value of our storage and the change from week to week. For this i use a waterfall chart which does a good job in showing the data i need. The data used is a qantity measure (assosiated with a date) which states if each transaction adds or removes value from the storage.

To get the correct cumulative value of all transactions i need to use all data from day 0 and sort increasing by week. This means that the latest values are on the far right of the chart. The problem is that every time i make a change to any of the filters etc on the page the chart jumps back to the far left. This is very annoying. I haven't been able to change the default appearance to show right instead of left. My application uses a SSAS cube Live Connection without the possibility to create report specific measures

BR

Henrik

[v-eqin-msft]

Hi @Mapei_Henrik ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Mapei_Henrik ,

I'm sorry that power BI is not able to achieve such a function now. 

For your issues, you could submit your idea here and vote up: https://ideas.powerbi.com/ideas/idea/?ideaid=4f5933e4-fcb6-425c-b2dc-efb804112854

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin