Forum Discussion

Enkei's avatar
Enkei
Frequent Visitor
5 years ago
Solved

Visual related

Hello ,   I am beginner in Power bi,  I want to know is it possible to divide sum of two columns visually?   Currently I am doing it by creating a new table and finding its result on new columns...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Enkei 

    yes, it is possible.

    I think the above visualization is not shown by measures, but it is shown by the sum of the female-column and the sum of the male-column. Please correct me if I am wrong.

    Do you want to show still two bars? Or, just one bar for the percentage of females?

     

    If it is OK with you, please share the sample pbix file, and I can try to come up with the desirable solution. 

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Enkei 

If it is OK with you, can you share your sample pbix file? Then, I can look into it to come up with a desirable solution.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

Enkei's avatar
Enkei
Frequent Visitor
5 years ago

Hello Jihwan_Kim ,

I have attached the table and visual.

what I want is ratio of total female by total male.

If it is possible from visual, I can use age slicer to find difference in each group.

 

tablevisual

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Enkei 

    yes, it is possible.

    I think the above visualization is not shown by measures, but it is shown by the sum of the female-column and the sum of the male-column. Please correct me if I am wrong.

    Do you want to show still two bars? Or, just one bar for the percentage of females?

     

    If it is OK with you, please share the sample pbix file, and I can try to come up with the desirable solution.