Forum Discussion

Julian_H's avatar
Julian_H
Helper II
2 years ago

Slicers and Filtering

Hi   I have had a request from a work collegue to be able to filter by the value selected  in  the slicer and a defualt value.   e.g. slicer has  A B C D E in it The selection is C which will fi...
Need Help
bhelou's avatar
bhelou
Responsive Resident
2 years ago

Hi , you can put it in a card or a table , 

for filter just drag and drop anything you want to make filter for it and set the conditions . 

hope this worked with you , if not share some sample of the PBIX file to go through it 

  • Julian_H's avatar
    Julian_H
    Helper II
    2 years ago

    Hi 

    I get the following when set up as a measure

     

     

    • kleigh's avatar
      kleigh
      Responsive Resident
      2 years ago

      Have you tried putting in brackets like (Accounts[Earnout_BoBNAme] = SelectedValue) ||  (Accounts[Earnout_BoBNAme] = "Z")  ?

      Sometimes when combining expressions with || the parts associate with a priority that does not match what might be expected. 

      • Julian_H's avatar
        Julian_H
        Helper II
        2 years ago

        Sorry but that doesnt work either