Forum Discussion

Julian_H's avatar
Julian_H
Icon for Helper II rankHelper 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
Icon for Responsive Resident rankResponsive 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
Icon for Helper II rankHelper II
2 years ago

Hi 

I get the following when set up as a measure

 

 

  • kleigh's avatar
    kleigh
    Icon for Responsive Resident rankResponsive 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
      Icon for Helper II rankHelper II
      2 years ago

      Sorry but that doesnt work either