Forum Discussion

Fabio_B's avatar
Fabio_B
Frequent Visitor
2 years ago
Solved

Simple column filter

Hello all, this is my very first post, so nice to meet you all. I'm approaching Power Bi since a while, but still struggling with this filter. I have an excel file like this:   What i woul...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Fabio_B ,
    Thanks to quantumudit and Greg_Deckler  previous quality answers, here's my solution to your new question
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:


    Following the previous steps I accomplished the following effect

    In order to add or remove line segments automatically, you can create a meaure and use filed parameter to achieve this effect.
    Create meaures

    Sum of FRANCE GAS = SUM('Table'[FRANCE GAS])
    Sum of FRANCE Power = SUM('Table'[FRANCE Power])
    Sum of ITALY GAS = SUM('Table'[FRANCE GAS])
    Sum of ITALY Power = SUM('Table'[ITALY Power])

    Based on these meaure to create filed parameter
    In order to realize the use of a filed parameter to control two different visual objects, first you need to make sure that the order of the two parameters is the same, and second you need to create a one-to-one relationship between the two parameters based on the Parameter order

    Final outputt

     

    Best regards,

    Albert He

     

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