display the values of a field according to the selected slicers

[nkasdali]

Hi All,

need you help please.

I've got a COMMENTS table with Year, Country & Comment values.

i want to display the Comment Values (possible to have more than one ) if the Year & Country matchs to my slicers (from my Date table and Country Table). If  no value is selected in both slicers, then display "no data ".

How can i do that ?

thanks 🙂

[Anonymous · Accepted solution]

HI @nkasdali ,

You can consider to write a measure to compare current row contestant and selection value and return tag. After these, you can use this measure on visual level filter to choose matched records.

Using the SELECTEDVALUE function in DAX

Applying a measure filter in Power BI

Regards,

Xiaoxin Sheng