How to use Revenue measure as slicer (drop down >100 Millions and <100 Millions Revenue)

[VikramAdi]

Hi Team,

User want to filter Revenue data using screen level slicer. Don't want to apply filter on filter pane.

I have a Revenue measure .it contains overall revenue amount. Here user need a slicer to check >100Million or <100Million Revenue Brands. So i want to add a slicer it contains >100M,<100M .when user click on on the slicer ,slicer drop down should visible >100M,<100M only. user flexbele to choose from drop down and filter the data. Currently my [Revenue]  measure is sum of amount.

How i can achive this . can anyone help me.

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached PBI file.

Hope this helps.

[v-yifanw-msft]

Hi @VikramAdi ,

Depending on the information you have provided, you can follow these steps below:

1.Add a new table as a slicer.

2.Add new measures.

REVENUE<400 =
IF ( SELECTEDVALUE ( 'Table 2'[SELECTED] ) = "<400" && [Revenue] < 400, 1, 0 )

REVENUE>400 =
IF ( SELECTEDVALUE ( 'Table 2'[SELECTED] ) = ">400" && [Revenue] > 400, 1, 0 )

FLAG = 
IF (
    SELECTEDVALUE ( 'Table 2'[SELECTED] ) = "<400",
    [REVENUE<400],
    [REVENUE>400]
)

3.Put FLAG in Filters.

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VikramAdi]

Thanks for your response @v-yifanw-msft . Your approch working fine. When i choose multi select in slicer result  coming empty.Single select working fine. can you please suggest for multi seletion(>400 and <400)

[v-yifanw-msft · Accepted solution]

Hi @VikramAdi ,

You can follow these steps below:

1.Add new table.

2.Add FLAG measure and put it into fliter.

FLAG = 
VAR _judgement =
    IF ( [Revenue] > 400, ">400", "<400" )
RETURN
    IF ( _judgement IN ALLSELECTED ( 'Table 2'[SELECTED] ), 1, 0 )

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.