Forum Discussion
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.
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 featuresAfter 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 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
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
- ImPranavNew Member
Data Pane unavailable
Now my data pane is not showing up kindly need help with the same. Thanks.
- Ritaf1983Super 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
- 24601Frequent 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.
- ImPranavNew Member
- Ritaf1983Super 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 featuresAfter 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