Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Mandatory Selection in Binary Slicer

Hello everyone, I currently have a report which is fed with a table that contains orders from multiple customers for various years in which the orders may be in 1 of two states, Gross or Net. An ord...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    Try the folllowing:

    • Create a disconnected table with the states (Gross and Net)
    • Add the following measure:
    Filtering =
IF (
    SELECTEDVALUE ( 'StatesSlicer'[State] ) = "Net",
    COUNTROWS ( FILTER ( 'Table', 'Table'[State] = "Net" ) ),
    1
)

     

    Use the measure has filter of your visualizations all values that aren't blank:

     

    Check PBIX file attach.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

Try the folllowing:

  • Create a disconnected table with the states (Gross and Net)
  • Add the following measure:
Filtering =
IF (
    SELECTEDVALUE ( 'StatesSlicer'[State] ) = "Net",
    COUNTROWS ( FILTER ( 'Table', 'Table'[State] = "Net" ) ),
    1
)

 

Use the measure has filter of your visualizations all values that aren't blank:

 

Check PBIX file attach.