Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sunil222
Helper II
Helper II

How to club 3 matrix vizs into one viz

How to club 3 matrix vizs into one viz , 3 vissuals having different formulaes but structure and column names are same.

 

please guide me on this.

 

sunil222_0-1716289293560.png

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @sunil222 ,

 

Are there three different tables containing "Revenue", "Direct Cost", "Gross Margin", " Gross Margin%", you can append the tables into a single table and use the Switch() function to determine this.

In Power Query – Append Queries -- Append Queries as new – Three or more tables -- add

vyangliumsft_0-1716360802702.png

vyangliumsft_1-1716360802706.png

Note:

According to Power BI design, each column of data format needs to be consistent, so when merging multiple tables, Power BI will automatically determine the same data format according to each table, and finally display the same data format, if you want to display the value + percentage in a column, you need to use the Format() function with the switch() function to specify a column data to present the style of the specified data format, but Format() according to the specified format will be converted to text

FORMAT function (DAX) - DAX | Microsoft Learn

If the above doesn't meet your expectations.,can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

Best Regards,

Liu Yang

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

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @sunil222 ,

 

Are there three different tables containing "Revenue", "Direct Cost", "Gross Margin", " Gross Margin%", you can append the tables into a single table and use the Switch() function to determine this.

In Power Query – Append Queries -- Append Queries as new – Three or more tables -- add

vyangliumsft_0-1716360802702.png

vyangliumsft_1-1716360802706.png

Note:

According to Power BI design, each column of data format needs to be consistent, so when merging multiple tables, Power BI will automatically determine the same data format according to each table, and finally display the same data format, if you want to display the value + percentage in a column, you need to use the Format() function with the switch() function to specify a column data to present the style of the specified data format, but Format() according to the specified format will be converted to text

FORMAT function (DAX) - DAX | Microsoft Learn

If the above doesn't meet your expectations.,can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

Best Regards,

Liu Yang

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

AsNa_92
Helper I
Helper I

Hi @sunil222 

 

could you provide a sample data please.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.