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. 

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.