not able to achieve slicer

[Anonymous]

i am having meaures column in %

ID Value

A  10

b   20                                      so slicer should show two categories A 

c    30                                                                                                 B

d    40

e    50

f     60

if(value >30 ,value<50,"A","B")

But i am getting only one value in slicer ,how to achieve two values in slicer

[AkhilAshok]

Does the ID and Value corresponds to the Table columns? If yes, then create a calculated column with similar logic as you mentioned should work for a slicer:

Category = IF(Table[Value]>30 && Table[Value]<50, "A", "B")

[Anonymous]

i am trying same query on dummy data i am abe to achieve,while i am applying business data ,failed to achieve

any alternative like creating table with two row A  and B and and doing some calculation

[v-chuncz-msft · Accepted solution]

@Anonymous ,

Check if it is affected by other Slicers, Page level filters and Report level filters.

[AkhilAshok]

Are you sure there are values in your Business data which falls in both the categories?

[Anonymous]

Yes ,for example we have to make like that ,if value>80 show as  "A" else "B"

[Anonymous]

i tried even though i am gettting single value in slicer