Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ImPranav
New Member

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

Screenshot_1.jpg

 

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!

2 ACCEPTED SOLUTIONS
Ritaf1983
Super User
Super User

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

Ritaf1983_0-1686399723504.pngRitaf1983_1-1686399754310.png

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



View solution in original post

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.

 

Ritaf1983_0-1686401749374.png

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

 

View solution in original post

12 REPLIES 12
ImPranav
New Member

@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.Screenshot_2.jpg

Thanks again!

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

Ritaf1983_0-1686404459685.png

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



 

I want this :

Screenshot_3.jpg

 

But I am getting this :

 

Screenshot_4.jpg

 

@Ritaf1983 

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.

Hi @ImPranav 
I am not sure what you mean. Could you please provide an example?

Hi @Ritaf1983 ,

Screenshot_3.jpgScreenshot_4.jpg

What I mean to say is in the first picture shown, we can clearly see the order date hierarchy when its dragged into the data column.

But in my example which is the second image, I am not able to get the same hierarchy rather I am getting the whole 'Order date' data. 

Because of which I am unable to represent my data solely based on years/months/dates rather it is showing some numbers such as [42372,42373,42374,42375 etc.] as we can clearly observe in the images provided by me.

 

Thanks alot for your assistance and guidance, and apologies for any inconvenience caused @Ritaf1983 

 

Hi @ImPranav 

I think you're at the point where you should create a date table and work with it.

Please refer to the linked guide:

https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial

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

Ritaf1983
Super User
Super User

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

Ritaf1983_0-1686399723504.pngRitaf1983_1-1686399754310.png

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



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. 

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:

Ritaf1983_0-1699618555759.png

Ritaf1983_1-1699618612947.png

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

Data Pane unavailableData Pane unavailable

 

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

@Ritaf1983 

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.

 

Ritaf1983_0-1686401749374.png

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

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.