Forum Discussion

vmonu's avatar
vmonu
Helper II
6 years ago
Solved

Multiple value in a bar chart

Good day all,

I want to show the data that comes from 2 fields.

Say  Resolution,  Percentage , Total vtes

         Yes             46.5               1519

         No             53.5                1743

 

 

 

Currently the bar chart accepts only ONE of them (say percentage or Votes).

How can i have them in 1 bar chart ( i don't want to occupy by 2 charts

 

Thanks

MN

Need Help
  • vmonu's avatar
    vmonu
    6 years ago

    So unfortunately, as of this time... there is no easy wasy to put 2 values in BARCHART horizonatally..
    Again this is the ONLY stop gap or backup  thing alternative that's available... i wish they make it more easy..

    So i ended by doing this ... in the table .. by doing conditional format and so see the image below.

     

    Thanks again ..

    Let me know if you find another solution... by for time being i am accepting this as my solution.

     

    Best

    MN

11 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Try combo chart from Visualization pane where you put the total as a column value and Percentage in Line value and resolution in x-axis.

     

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    6 years ago

    Have you considered and line and column chart?  You can have separate Y axes. Another way would be to use Data Bars conditional formattting in a matrix visual. 

     

    If you can't find a visual that meets your needs, you could also consider making your own visual with Charticulator.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Why dont you create a calculation column "VotesANDPercentage" and merge votes and percentage

     

    VotesANDPercentage= Percentage&(&"Total vtes"&)

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards

     

    • vmonu's avatar
      vmonu
      Helper II
      6 years ago

      Anonymous  and V-lianl-msft ,

       

      Good idea but when i try to add it as value in the bar chart it is showing as COUNT or COUNT distinct and not the value... so it is showing 1 for all.

       

      Thanks

      MN

    • vmonu's avatar
      vmonu
      Helper II
      6 years ago

      Unfortunately .. no they want to see both of them ...
      THe only option i can think of is ... put 2 bar charts... but that's clumsy .

       

      Thanks

      MN

      • vmonu's avatar
        vmonu
        Helper II
        6 years ago

        V-lianl-msft  I wonder how come, no one has faced this ask before..

         

        It's pretty common to have multiple measures for same metrics.

         

        I am surprised that this was not there before.

         

        Thanks friend for your help

         

        Regards
        MN

  • mhossain's avatar
    mhossain
    Solution Sage
    6 years ago

    Hi vmonu 

     

    I think if you use Table/matrix visuals and format this well and apply dynamic conditional formatting with data bar etc, you will occupy just one vsiual, try if this makes sense. Let me know if you require more details and your findings please.

    • vmonu's avatar
      vmonu
      Helper II
      6 years ago

      mhossain 

       

      Yes table and matrix works... but the users (and even i ) want to see the Bar charts... 

      Remember it showing internal polling and they would like to see  Percentage and votes for it... so showing as table looks like an excel sheet 🙂  and defeats using PBI

       

      Thanks

      • mhossain's avatar
        mhossain
        Solution Sage
        6 years ago

        vmonu 

        Agree with you to great extent :). That is why mentioned if you are able to well format your table and apply conditional formatting so that it doesn't look like table.