Filter columns of a grid using different slicers

[Anonymous]

Hi Folks,

I have to implement a scenario wherein a particular column of a matrix in power bi must NOT interact with the slicer.

For example, Column 1 in the below table has the count for the number of shares purchased for a given account type (Date slicer1). Now I want to see the value of these shares over a period (Date slicer2). So, I want the count of shares as on 27th June and their respective values over a month (27/06 - 27/07) by Account type.

The slicers used to filter Column1 are different and that for rest of the months is different.

Data is being fetched in Direct Query mode.

Type	Col1 (Contains count)	Col2 (Contains value)	Col3 (Contains Value)
A	4	76	54
B	6	45	87
C	2	65	32

Thanks,

Nikita

[amitchandak]

@Anonymous , you need to have three slicers, refer these two slicer example

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

I would use Dax and create seperatee measures 

if you use allexcept function you can create a measure that will ignore the filters or slicers you dont want it to interact with 

https://docs.microsoft.com/en-us/dax/allexcept-function-dax

[parry2k · Accepted solution]

@Anonymous in your measure use ALL 

Total = CALCULATE ( SUM ( Table[Shares] ), ALL ( Table ) ) 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡