Forum Discussion

edmundhall's avatar
edmundhall
New Member
7 years ago
Solved

Slicer behaviour with matrices

Hi everyone, I was wondering if it is possible to set up a matrix visualisation so that only one group within the columns field interacts with a slicer? My understanding is that slicer interactio...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    edmundhall you need to create measures.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

edmundhall for keep your measure at fixed value, you can change the measures as below:

 

 

Budget Fixed = 
CALCULATE ( 
SUM( YourFact[Budget] ), 
ALLCROSSFILTERED( YourDateDimensionTable )
)
edmundhall's avatar
edmundhall
New Member
7 years ago

Yes, I've read about various operations to prevent filtering on specific measures, but my issue is that the items I have in the values field of the matrix are calculated columns of a table, rather than measures.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    edmundhall you need to create measures.

    • edmundhall's avatar
      edmundhall
      New Member
      7 years ago

      Yeah, that worked! It would be great to have a feature where columns could be excluded from a slicer as the way the grouping would be a little nicer in a matrix - hopefully this feature might get implemented in the future