Create period chart with the last column show accumulative value

[ngocnguyen]

Hi.

I wanna create a matrix with row "Accu" at the bottom (showing the accumulative value) as below

in my dashboard, there is 1 slice month

So , is there any way to create this table?.

I started with some Dax like 

DD ratio on visual chart =

VAR monthselected=SELECTEDVALUE(table[Month])

RETURN

IF(monthyearselected="Accu",Calculate( [Current ratio],

DATESYTD('Dimdate[date])

,[Curent ratio])

but it not working:(((. could you please suupport me

[OvaisJanzeb]

please share an example file that will help us to more understand your requirement

[ngocnguyen]

Hi @OvaisJanzeb 

I already upload my PBI as below link. 

I wanna create a Bar chart with Accu column in the end

When I choose "Month Year" Slicer. the Bar chart just show data from beginning of fiscal year to the selected month and Accu results only

https://drive.google.com/file/d/1BSxQsCNmpJm2fqBPPUKC-FvVyCr1ijwC/view?usp=sharing 

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523