Forum Discussion

BernardesV's avatar
BernardesV
Frequent Visitor
2 years ago

Cross-filtering multiple table visuals into one line chart

Hello everyone,

 

I have a project where I use only one source, having the parameters "Product", "Sales", "Date", and "Price".

I'm trying to create two Tables (visuals) and my wish is to be able to select one product in each Table, and having both products displayed under the same Line chart.

When selecting two products under the same visual this works and I can see the price development throughout the dates, however when selecting one product under each table the Lines disappear and my chart becomes empty.


Scenario 1, where it doesn't work:

Scenario 2, where it works:

Would it be possible somehow to make the scenario 1 works in PowerBI, keeping the selection in 2 different tables and having the results displayed under the same line chart?

For me it's important to keep the same line chart to be able to compare the price development for both products.

Any hints are more than appreciated. Thank you so much in advance.

 

Best regards,

Bernardes

Need Help

3 Replies

  • VN999's avatar
    VN999
    Resolver I
    2 years ago

    Try with this below measure to solve combine productselection:

     

    CombinedProductSelection =
    IF (
    ISFILTERED('Product'[Product Name]),
    SELECTEDVALUE('Product'[Product Name]),
    CONCATENATEX(
    VALUES('Product'[Product Name]),
    'Product'[Product Name],
    ", "
    )
    )

  • BernardesV's avatar
    BernardesV
    Frequent Visitor
    2 years ago

    Hi VN999,
    I've tried to implement the measure you described in different ways. It's not possible to be applied as part of the line chart and in the tables it doesn't work the expected way.