Show Medium, Low and High data representation

Question

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, then all the product listed parallel to that will show in the low card
Second, if the sales value is between the selected range, then all the product listed parallel to that will show in the midcard
Third, if the sales value is above the selected range, then all the products listed parallel to that will show in the high card.
So, basically, the user will change the sales value in the slicer, and then the card should change accordingly.
For example, if a user is selecting 100 to 140, then all the products with values below 100 should appear in the low card, 100 to 140 value products should appear in the mid card and any product value greater than 140 should appear in the third high card.

Here we have two challenges. First, create a formula for all three conditions. Second, to create a slicer to filter out the values based on a range.

Any suggestions from anyone is really appreciated. Thanks!

jihwan_kim · Answer

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.
&nbsp;
CC_slicer = 
VAR _min =
    MIN ( sales[sales] )
VAR _max =
    MAX ( sales[sales] )
RETURN
    SELECTCOLUMNS ( GENERATESERIES ( _min, _max, 1 ), "sales_range", [Value] )
&nbsp;
&nbsp;

&nbsp;
&nbsp;

&nbsp;
product list below selection: = 
VAR _minselect =
    MIN ( CC_slicer[sales_range] )
VAR _t =
    FILTER ( sales, CALCULATE ( SUM ( sales[sales] ) ) &lt; _minselect )
RETURN
    CONCATENATEX ( _t, sales[product], ", " )
&nbsp;
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] ) ) &gt;= _minselect &amp;&amp; CALCULATE ( SUM ( sales[sales] ) ) &lt;= _maxselect )
RETURN
    CONCATENATEX ( _t, sales[product], ", " )
&nbsp;
product list above selection: = 
VAR _maxselect =
    MAX ( CC_slicer[sales_range] )
VAR _t =
    FILTER ( sales, CALCULATE ( SUM ( sales[sales] ) ) &gt; _maxselect )
RETURN
    CONCATENATEX ( _t, sales[product], ", " )
&nbsp;

surekha_pm · Answer

Hi&nbsp;Jihwan_Kim&nbsp;,Thank for your help. This is showing the result. But it is showing duplicate data where I need unique names. Also, Can we show it one below other rather than the default visual where it is separating with comma.For example, currently it is showing as A,B,C,D.&nbsp;I want it to show like belowABCDThanks!

surekha_pm · Answer

Also, if I am filtering 500 to 3000, the product of 500 value is showing in the low as well as med card. Same way 3000 value product is showing in med as well as high.
Can we do it like this: in the med card, the product should reflect the 501 value, and in the high card, it should be 3001 and above?

jihwan_kim · Answer

Hi,
In my sample, I cannot filter to show between 500 to 3000.
If you are using different sample pbix file, please kindly share the link.
Or, please try fixing &gt;= to &gt; in your formula.
Thank you.

ashish_mathur · Answer

Hi,
Share some data to work with and show the expected result.&nbsp; Share data in a format that can be pasted in an MS Excel file.

Forum Discussion

Show Medium, Low and High data representation

9 Replies

Related content

Bradley Terry score representation - visuels?

Better visual representation

graphic representation

Best representation to show order spread

Dashed Line Representation for Future Dates