Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional formatting via isinscope()

Hi All, Via a measure and the function isinscope() I assigned conditinal formatting on 3 different hierarchical levels (matrix rows). This working just fine, but the business wants to have a butto...
Conditional Formatting
Filter using a measure
isinscope
matrix
measure
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    What is your desired output?  I'm a little confused. When we select the level 1, we can see level 2 and level 3. But when we choose level 3,  Its upper level cannot be hidden.

     

    If so, you can vote here: Microsoft Idea (powerbi.com)

     

    Best Regards

    Community Support Team _ Polly

     

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous, 

There was nothing wrong with the formula. I was looking at a way where I can filter based on this formula. 

So when 1 hierachy is matched, I want to see all the details from level 1 to level 3 of a certain country for example, NL.

So in this example hierachy level 2 is matched for the countries NL and DE. Therefore I want to see all the details on that level:

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

Do you have any idea? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    What is your desired output?  I'm a little confused. When we select the level 1, we can see level 2 and level 3. But when we choose level 3,  Its upper level cannot be hidden.

     

    If so, you can vote here: Microsoft Idea (powerbi.com)

     

    Best Regards

    Community Support Team _ Polly

     

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