Quarter data display in bar chart

[shalini13]

hi ,

I want to display cumulative quarter wise data for the selected quarter in the slicer along with the previous quarter. for an instanace, if i select Q2, then the total sales value for the Q1 & Q2 has to be displayes in the bar chart. Here I used calendar table for slicer. 

this is the dax, i used, 

cumm_bar = CALCULATE

(

           COUNTROWS(PurchaseOrder),

            FILTER

            (

              ALL( CalendarTable),

              CalendarTable[Quarter] <= MAX(CalendarTable[Quarter])

              && CalendarTable[Year] = MAX(CalendarTable[Year])

)). 

in this case, i always get the value for the quarter that i select in the slicer not for the previous ones. please help. TIA.

[Anonymous]

Hi @shalini13 ,

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 if you are still confused about it, please feel free to let me know.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Ahmedx]

for it to work for you, you must create an unrelated table like I have in the "Slicer" file
and use it for slicing

[shalini13]

If i use a disconnected table then it does but my other charts  get affected. here is my file https://drive.google.com/file/d/1ri8pLxdwQ5dLQFgUUDBTDYW4MsKWcUFP/view?usp=drive_link 

[Ahmedx]

with an active connection it will not work

[shalini13]

Is there any other way to approach so that other charts in the page will not get affected. TIA

[Ahmedx]

you need to change the RELATION to inactive and change all the measures that are associated with them and activate them using USERELATIONSHIP

https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/

[Ahmedx]

[shalini13]

This solution doesnt work for me  . i am getting bar only for the selected quarter. 

[shalini13]

Hello ahmed,

 can i know how the key is created and a brief explanation about it. please.

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[shalini13]

i am looking for similar output. let me try and came back. thanks a ton