display in the matrix only those values ​​where there is a price

[pani_victoria]

Colleagues, hello!

I need your help )

Attached is an example where I am trying to implement a price comparison relative to the selected brand.

The idea is this:

In the "Choose comp" slicer - select the brand relative to which we are making a comparison
In the "Choose" slicer - select the brands we want to compare.

The table displays both prices and price deviations.

The problem that I really want to solve is displaying in the table only those items that have prices of the selected brands.

For example, in the "Choose" slicer - all are selected, in this case only the dress product has prices - that's one line and it should be displayed.
If you select Brand 1,2 and 4, then the scarf, pants, blazer, dress products should be displayed.

Is this possible? Can someone help?

price_comparison.pbix 
P.S. select date 24/02/25 in the report

[Akash_Varuna]

Hi @pani_victoria You could achive this by a custom measure could you try these please 

• Create a Measure for Filtering Rows:

  •  Formula
    Show Row = IF( NOT(ISBLANK(MINX(FILTER(VALUES('Table'[Brand]), NOT(ISBLANK('Table'[Price]))), 'Table'[Price]))), 1, 0 )

• Add the Measure as a Visual-Level Filter:

  • Drag the Show Row measure to the Filters on this visual pane in the matrix.
  • Set the filter condition to is 1.

• Adjust Slicers:

  • Ensure your "Choose comp" and "Choose" slicers are correctly linked to the matrix via the appropriate relationships in your data model.
    If this post helped please do give a kudos and accept this as a solution
    Thanks In Advance

[pani_victoria]

@Akash_Varuna 
Thanks for the answer, but unfortunately this idea doesn't work.
My matrix didn't react to the filter at all. Maybe I'm doing something wrong

[Anonymous]

Hi, @pani_victoria 

I failed to open your link. Can you re-provide the example file and the output? Please remove any sensitive data in advance.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

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

[pani_victoria]

Hi!
I updated the link)