Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If/like function in slicer

Hi,

I have just started using PowerBI with some learning and created a report and stuck with below issue.
I have a slicer with items like in image and I want items to be shown individually (no combinations like Azure AD and Citrix).  If someone selects Azure AD, it should give all the results where Azure AD exists (10+8+5 results as per example).

 

Slicer image

I have come across a similar query but it is about the count in a card but not the actual results. This slicer is synced with other charts/graphs and pretty much everything on the report. 

https://community.powerbi.com/t5/Desktop/If-contains-function-with-a-filter/td-p/331372


With example numbers:

Azure AD (10)

Azure AD and App proxy (8)

App proxy (7)

Citrix (6)

Azure AD and Citrix (5)


Kindly help.

Regards,

Sudheer

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

    Nope, slicer not support 'like' operation on its items.
    I'd like to suggest you to write a measure to check current row counts and selected item and return tag. After these, you can use this measure on 'visual level filter' to filter matched records to achieve 'like' filter effect.

    Regards,
    Xiaoxin Sheng