cancel
Showing results for 
Search instead for 
Did you mean: 
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
Community Champion
Community Champion

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

10 REPLIES 10
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
Community Champion
Community Champion

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



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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors