Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Group values in column chart/bar chart

Hey All, I want to grop the blanks value to another bar. Is it possible? For example, I want that blanks will be counted with code 9. So blank will be removed from the chart and 9 will show 292 + 5...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    By my tests, the solution of parry2k should be helpful.

    I have made a test pbix to reproduce your scenario.

    In addition, you could have a reference of the attachment.

    Best  Regards,

    Cherry

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous did you tried what I sent? Not sure why you have to have more if condition, i think ask is if blank then 9 else whatever the code value is, isnt it?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey parry2k ,

Not accurate.

I am trying to map the codes to readable values. Sorry, I cannot write the real values due to sensetive data.

I am using numbers here just to ilustrate.

So, if code is 1, show text_1,

if code is 2, show text_2

...

if code is 9 or blank, show text_9

 

So the users can read the values and not guess what is the meaning of each code.

 

Ta!

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous interesting, you can use switch statement, easy to work with

     

    Switch ( Table[Code] ,
1, "Whatever text",
2, "Whatever text",
9, "text for 9",
"text for 9" --this will be final condition if nothing matches above and blank will fall here
    )
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      parry2k 
      Although switch and if are the same, from logical perspective, I tried to use switch.
      I am still with the same results.
      New Code =
      SWITCH(Table[CODE],
      "1", "Text_1",
      "2", "Text_2",
      "3", "Text_3",
      "4", "Text_4",
      "9", "Text_9",
      "Text_9")


      For some reason Power BI is not catching these blanks. Not sure why though.

       

      Thanks!

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        Anonymous can you share visual like before using with new code on x axis

         

        if possible, please share pbix, remove any sensitive information, we are surely missing something here.