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

     

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi parry2k 
    I tried to export to csv the data, but clearly it works there and the visual shows correctly.

    My original dataset is a Firebird DB.

    Not sure how to share the PBIX without revealing the data.

    Ta!