Hi colleagues, I use diagram (screenshot) for tracking % of running total. How I can do the same visualization in PowerBI environment? Do I need to use one of existing visuals or I need to create customized visual? If so, please help me to create my own visual. I'm adding screenshot to show you what exactly I do via Excel.
In general, you would create a measure or column (probably a measure) that would contain your % of running total and then just add that measure a line chart visualization. If you provide some sample data, I could be more specific but you can check out the following link for a DAX pattern for running total:
Thanks for idea! I probably can do running total via DAX, but I still have problems with P-04 period. Running total should be calculated in this column not as 100% for current SubPeriod, but as % of Projection (cell W26 in attachment). Also, calculation of this value should be sensitive for SubPeriods: there shouldn't be any data on pivot/graph (cells P44 - P49 in attachment).