cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBIUser007
Frequent Visitor

Formatting option to merge repeated measure values to a single cell

Hi All,

 

Is there a way to merge the measure values to a single cell in a table/matrix or similar visual?

 

I was able to merge the category values using a matrix visual as given in image 1 (Used row header properties). Similarly, I have a requirement to merge the "category avg %" as well as shown in image 2. But i was not able to find a way to do this. Can anyone help me here?

 

PBIUser007_0-1619712200500.png

 

PBIUser007_2-1619712227012.png

 

Thanks in Advance,

 

7 REPLIES 7
amitchandak
Super User
Super User

@PBIUser007 , Try like

calculate([delivery %], filter(allselected(Table) , table[category] =max(Table[Category])))

or

calculate(AverageX(values(Table[product]),[delivery %]), filter(allselected(Table) , table[category] =max(Table[Category])))



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

Thanks a lot for your reply. I'm looking for a formatting option to merge/group the measure cells. For example i want to show 97% only 1 time for category 1 as shown in image2 instead of repeating the value 3 times as in image1. Do you think this is achivable in any table or similar visual in power BI?

 

Thanks in Advance,

Hi, @PBIUser007 

As far as I’m concerned, Matrix in Power BI can not achieve the function to display the merged cells.

Here’s a case that deals with the status that you have to drill through in the matrix:

https://community.powerbi.com/t5/Desktop/Merge-cells-in-tabular-visualization/m-p/737221

 

If you still have a problem, you can go to the Power BI Idea to submit a new idea so that people with the same idea can vote for you. I will also vote for you.

v-robertq-msft_0-1620117419853.png

 

Or you can just vote for this idea:

https://ideas.powerbi.com/ideas/idea/?ideaid=b03e39a3-78e8-48c7-b2fa-70c5e0ea6ff3

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

Thank you. I was able to merge the dimension columns in the row section using a matrix visual.

 

I was looking for an option to merge the repeating measure values (placed in value section). It looks like it's not possible in power BI.

 

PBIUser007_0-1620122874064.png

 

 

Thanks in Advance,

Hi, @PBIUser007 

Yes, but I think it is a pretty good idea to improve the Power BI. So I suggest you to go to the Power BI Idea to submit a new idea so that people with the same idea can vote for you as mentioned above. I will also vote for you.😁

v-robertq-msft_0-1620177743116.png

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

I've voted for this idea.😁

v-robertq-msft_1-1620265684406.png

 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors