How to select only one row value if one value is selected

Power BI
1

Hello , Here is my PBXI file attached.
test report.pbix (282.5 KB)

Problem: I want to achieve when any user will select only Product Category and Product name is not selected , In the column chart visual it should automatically show only one Product Name having Max row number with Profit.

Thank you .

2

Did not quite understand. Would it be something like that? If not, can you cite an example?

Sem título
Sem título1348×395 24.8 KB

3

Yes you are correct . Please share the details

4

See if it helps you

test report.pbix (282.7 KB)