Forum Discussion

hanuraolm's avatar
hanuraolm
Icon for Helper I rankHelper I
3 years ago
Solved

Disply the values btween using Text Attri

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

BuildBuildID
1.8.4 - SP25-B1-Release251
1.8.4 - SP25-B2-Release252
1.8.4 - SP25-B3-Release253
1.8.4 - SP26-B1-Release261
1.8.4 - SP26-B2-Release262
1.8.4 - SP26-B3-Release263
1.8.4 - SP27-B1-Release271
1.8.4 - SP27-B2-Release272
1.8.4 - SP27-B3-Release273
1.8.4 - SP28-B1-Release281
1.8.4 - SP28-B2-Release282
1.8.4 - SP28-B3-Release283

 

 

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  

 

BuildBuildID
1.8.4 - SP25-B1-Release251
1.8.4 - SP25-B2-Release252
1.8.4 - SP25-B3-Release253
1.8.4 - SP26-B1-Release261
1.8.4 - SP26-B2-Release262
1.8.4 - SP26-B3-Release263

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • hanuraolm's avatar
    hanuraolm
    Icon for Helper I rankHelper I
    3 years ago

    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.