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. 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.

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. 

5 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super 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
        Super 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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Enkei
      Frequent Visitor
      5 years ago

      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