Disply the values btween using Text Attri

[hanuraolm]

Below is a sample of data. Based on Build Column, we need to create two slicers. Whenever the user selects values from buildFrom and buildTo, the visuals should display values from all builds between those values 

Sample Data

Build	BuildID
1.8.4 - SP25-B1-Release	251
1.8.4 - SP25-B2-Release	252
1.8.4 - SP25-B3-Release	253
1.8.4 - SP26-B1-Release	261
1.8.4 - SP26-B2-Release	262
1.8.4 - SP26-B3-Release	263
1.8.4 - SP27-B1-Release	271
1.8.4 - SP27-B2-Release	272
1.8.4 - SP27-B3-Release	273
1.8.4 - SP28-B1-Release	281
1.8.4 - SP28-B2-Release	282
1.8.4 - SP28-B3-Release	283

for Example user selected values as below then it should disply the values below and we can identify the order based on BuildID.

BuildFrom  -  1.8.4 - SP25-B1-Release

BuildTo  - 1.8.4 - SP26-B3-Release  

Build	BuildID
1.8.4 - SP25-B1-Release	251
1.8.4 - SP25-B2-Release	252
1.8.4 - SP25-B3-Release	253
1.8.4 - SP26-B1-Release	261
1.8.4 - SP26-B2-Release	262
1.8.4 - SP26-B3-Release	263

[hanuraolm]

It looks good. Using fromBuild, toBuild slicers, we can capture values and pass them to metrics to restrict the data.

For this requirement – BuildID column must require displaying the order of BuildName. After selecting we need to create another two slicer fromCehckin, toCheckin.

fromCehckin - these values should be between selected fromBuild,ToBuild.

toCehckin - these values should be between selected fromBuild,ToBuild.

For Example, in the below case if we selected fromBuild :- SP25-B2-Release toBuild:- SP25-B3-Release,

fromChekin slicer values are - 0.2011,0.2012,0.5013,0.1011,0.2012,0.6013

toChekin slicer values are - 0.2011,0.2012,0.5013,0.1011,0.2012,0.6013

both are same – now we need to allow use to select from fromChekin, toChekin

BuildName	BuildID	Checkin
SP25-B1-Release	251	0.1011
SP25-B1-Release	251	0.1012
SP25-B1-Release	251	0.1013
SP25-B2-Release	252	0.2011
SP25-B2-Release	252	0.2012
SP25-B2-Release	252	0.5013
SP25-B3-Release	253	0.1011
SP25-B3-Release	253	0.2012
SP25-B3-Release	253	0.6013
SP25-B4-Release	254	0.1011
SP25-B4-Release	254	0.1012
SP25-B4-Release	254	0.1013

Now if the user selected fromCheckin - 0.20110 and toCheckin -0.20120 then result would be like

BuildName	BuildID	Checkin
SP25-B2-Release	252	0.20110
SP25-B2-Release	252	0.20120
SP25-B3-Release	253	0.10110
SP25-B3-Release	253	0.20120

How can we capture the values for FromCheckin, tochecking based on between the selected fromBuildID, toBuildID.   Do we need any Order ID column for checkin or else is there any way to capture the values.

[Anonymous · Accepted solution]

Hi @hanuraolm ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create two dimension tables with the field [Build] and apply the field onto the slicers separately

2. Create a measure as below

Flag = 
VAR _buildfrom =
    SELECTEDVALUE ( 'Build From'[Build] )
VAR _buildto =
    SELECTEDVALUE ( 'Build To'[Build] )
VAR _frombid =
    CALCULATE (
        MAX ( 'Table'[BuildID] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Build] = _buildfrom )
    )
VAR _tobid =
    CALCULATE (
        MAX ( 'Table'[BuildID] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Build] = _buildto )
    )
VAR _selbid =
    SELECTEDVALUE ( 'Table'[BuildID] )
RETURN
    IF ( _selbid >= _frombid && _selbid <= _tobid, 1, 0 )

3. Create a table visual and apply a visual-level filter with the condition(Flag is 1)

Best Regards