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

[ImPranav]

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!

[Ritaf1983 · Accepted solution]

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]

@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!

[Ritaf1983]

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

[ImPranav]

I want this :

But I am getting this :

@Ritaf1983 

[ImPranav]

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]

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

[ImPranav]

Hi @Ritaf1983 ,

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 

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

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]

Data Pane unavailable

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

@Ritaf1983 

[Ritaf1983 · Accepted solution]

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