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

Can we make a table visual into summarized two column table

Can we make the the table visuals of multilple column turn into 2 column table for making it as a custom tool tip?

5 REPLIES 5
Community Support Team
Community Support Team

Re: Can we make a table visual into summarized two column table

HI @anishkrissh ,

It is hard to achieve your requirement by Dax formulas. I'd like to suggest you enter to query editor to create a new query table with combine function to combine these tables and do 'unpivot columns' to convert multiple fields to attribute and value. (Notice: build the relationship from merge table to original tables to enable interaction effect with original tables)

Unpivot columns (Power Query) 

Table.Combine 

Full query:

 

let
   Source=Table.Combine({Table1,Table2})
in
   Source

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
anishkrissh Frequent Visitor
Frequent Visitor

Re: Can we make a table visual into summarized two column table

Can You show me?

 

Community Support Team
Community Support Team

Re: Can we make a table visual into summarized two column table

Hi @anishkrissh ,

If you can please share some dummy data with the same data structure for test.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Highlighted
anishkrissh Frequent Visitor
Frequent Visitor

Re: Can we make a table visual into summarized two column table

Community Support Team
Community Support Team

Re: Can we make a table visual into summarized two column table

HI @anishkrissh ,

I can't get sample file from your link, I'd like to suggest double-check the share setting to confirm share feature works.

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)