Forum Discussion

itsmeanuj's avatar
itsmeanuj
Helper IV
3 years ago
Solved

Difference between 2 bars

Hello,  I need help in creating something similar (kind of waterfall model) visual in PBI. where we want to showcase the difference between 2 bars like this. Data contains more than 1000 rows so I h...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    itsmeanuj My guy. You just take the Diff measure and break it into 3 measures, one for each difference value. PBIX is attached below signature.

    IP Diff = 
    VAR __Axis = MAX('Versions'[Version])
    VAR __Result = 
        SWITCH(__Axis,
            "IP Diff",
                    VAR __1 = SUMX(FILTER('Table',[Versions] = "IP"),[Value])
                    VAR __2 = SUMX(FILTER('Table',[Versions] = "FC1"),[Value])
                    VAR __Result = IF(__1 < __2, __2 - __1, __1 - __2)
                RETURN
                    __Result,
            BLANK()
        )
RETURN
    __Result



FC1 Diff = 
    VAR __Axis = MAX('Versions'[Version])
    VAR __Result = 
        SWITCH(__Axis,
            "FC1 Diff",
                    VAR __1 = SUMX(FILTER('Table',[Versions] = "FC1"),[Value])
                    VAR __2 = SUMX(FILTER('Table',[Versions] = "FC2"),[Value])
                    VAR __Result = IF(__1 < __2, __2 - __1, __1 - __2)
                RETURN
                    __Result,            
            BLANK()
        )
RETURN
    __Result





FC2 Diff = 
    VAR __Axis = MAX('Versions'[Version])
    VAR __Result = 
        SWITCH(__Axis,          
            "FC2 Diff",
                    VAR __1 = SUMX(FILTER('Table',[Versions] = "FC2"),[Value])
                    VAR __2 = SUMX(FILTER('Table',[Versions] = "FC3"),[Value])
                    VAR __Result = IF(__1 < __2, __2 - __1, __1 - __2)
                RETURN
                    __Result,
            BLANK()
        )
RETURN
    __Result

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

itsmeanuj If the standard waterfall chart won't work you'll need to check out the App Store for custom visuals that may work or use something like Deneb custom visual. 

itsmeanuj's avatar
itsmeanuj
Helper IV
3 years ago

Greg_Deckler - So is it not possible to play around with some measures to show data in this visual format? like the difference between 2 bars?

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    itsmeanuj Oh, it might be possible given a disconnected table, a stacked bar chart and a fancy measure but it's not going to be easy. I'll see if I can pull something out of the hat.

    • itsmeanuj's avatar
      itsmeanuj
      Helper IV
      3 years ago

      Thank you Greg_Deckler . This is helpful. But if you see the sample visual i shared,  I am actually looking for differences in IP, FC1, FC2, FC3. 

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        3 years ago

        itsmeanuj That's great but you didn't provide sample data that included different Versions.