Visual related

[Enkei]

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. But while doing this, I could not use slicers.

So if there is any visual to divide it directly from report, i can use slicers to filter only rows I want.

[Anonymous]

Hi @Enkei 

Can you share an example of what your table looks like and what is your expectation.

Posting your queries with sample input and output helps get your queries answered  quicker.

[Enkei]

Hello Praneet, 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]

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]

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 · Accepted solution]

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.