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

     

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

Hi,

In the Table where you have dragged the Codes from, create this calculated column formula

=IF(ISBLANK(Data[Codes]),9,Data[Codes])

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ashish_Mathur ,
Thanks.

This was the first solution from parry2k .

Please read previous comments.

Thanks

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

    Anonymous I'm you surely checked this but can you use your actual data on x-axis and check if your see (blank) on x-axis or space/nothing, wondering if it is actually not blank but some other non-printed character value, although that would have been captured in switch statement.

     

    Just trying to think out of the box even it is not logical.

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    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