Forum Discussion

Surekha_PM's avatar
Surekha_PM
Icon for Resolver I rankResolver I
1 year ago

Show Medium, Low and High data representation

I have a data set with multiple columns. I need to show three different condition product lists in three different cards (one below the other). First, if the sales value is below the selected range,...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I tried to create a slicer table (Calculated Table) by using the formula below.

 

CC_slicer = 
VAR _min =
    MIN ( sales[sales] )
VAR _max =
    MAX ( sales[sales] )
RETURN
    SELECTCOLUMNS ( GENERATESERIES ( _min, _max, 1 ), "sales_range", [Value] )

 

 

 

 

 

product list below selection: = 
VAR _minselect =
    MIN ( CC_slicer[sales_range] )
VAR _t =
    FILTER ( sales, CALCULATE ( SUM ( sales[sales] ) ) < _minselect )
RETURN
    CONCATENATEX ( _t, sales[product], ", " )

 

product list between selection: = 
VAR _minselect =
    MIN ( CC_slicer[sales_range] )
VAR _maxselect =
    MAX ( CC_slicer[sales_range] )    
VAR _t =
    FILTER ( sales, CALCULATE ( SUM ( sales[sales] ) ) >= _minselect && CALCULATE ( SUM ( sales[sales] ) ) <= _maxselect )
RETURN
    CONCATENATEX ( _t, sales[product], ", " )

 

product list above selection: = 
VAR _maxselect =
    MAX ( CC_slicer[sales_range] )
VAR _t =
    FILTER ( sales, CALCULATE ( SUM ( sales[sales] ) ) > _maxselect )
RETURN
    CONCATENATEX ( _t, sales[product], ", " )