Forum Discussion

ImPranav's avatar
ImPranav
New Member
3 years ago
Solved

summarization table does not has 'Show value as' Option.

 

I am trying to use show values as percentage function through summarization table, but that option seems to be missing in the table. I am using latest version of power bi [May 2023]. Attaching below screenshot of the summarization table.

 

amitchandak Ahmedx Ritaf1983 

 

Thanks in advance and sorry for any inconvenience caused!

  • Hi ImPranav 
    You need in the first step select the type of aggregation and than how to show it:

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly



  • Hi again ImPranav 
    I saw that with "graph on object" feature works in a little different way.
    After step 1 of choosing aggregation, you need right click on a value to open the window of choosing how to show it.

     

    Please also refer to my recorded screens: Link to recorded screens video 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

     

  • If you want to locate the data pane on the right side, you need to check off the option of "on object interaction":
    From File << Options and settings <<Options << Preview features

    After modifying you need to close and reopen the power bi desktop.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly



     

  • Hi 24601 
    Yes, it works for the measures too...but a little less intuitive:
    instead of a left click, you should give a right click on the measure:

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

12 Replies

  • Hi ImPranav 
    You need in the first step select the type of aggregation and than how to show it:

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly



    • ImPranav's avatar
      ImPranav
      New Member

      Data Pane unavailable

       

      Now my data pane is not showing up kindly need help with the same. Thanks.

      Ritaf1983 

      • Ritaf1983's avatar
        Ritaf1983
        Super User

        Hi again ImPranav 
        I saw that with "graph on object" feature works in a little different way.
        After step 1 of choosing aggregation, you need right click on a value to open the window of choosing how to show it.

         

        Please also refer to my recorded screens: Link to recorded screens video 

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

         

    • 24601's avatar
      24601
      Frequent Visitor

      Is there a way of doing this for measures? I was previously able to but with the new update it looks like I can't.

      Some of my visuals are now showing the value instead of the % of total as it previously was. 

      • Ritaf1983's avatar
        Ritaf1983
        Super User

        Hi 24601 
        Yes, it works for the measures too...but a little less intuitive:
        instead of a left click, you should give a right click on the measure:

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • Ritaf1983 Thanks alot for providing an executable solution for my first instance. Also can you kindly provide another solution for my recent problem where i am unable to locate data pane on the right side.

    Thanks again!

      • ImPranav's avatar
        ImPranav
        New Member

        HI Ritaf1983 Thanks for your assistance for my previous queries, can you kindly help me with the above issue where i am not able to locate different types of order date in the drop down of that particular data type.

    • Ritaf1983's avatar
      Ritaf1983
      Super User

      If you want to locate the data pane on the right side, you need to check off the option of "on object interaction":
      From File << Options and settings <<Options << Preview features

      After modifying you need to close and reopen the power bi desktop.

      If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly