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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Create a table using multiple measure and tables

I had created 4 measure based on table 1 selection and same measures for table 2 and getting the correct values

Surya9_0-1622116841989.png  

Surya9_2-1622116948471.png

Now I want to combine both this tables like

Surya9_3-1622116989001.png

Is there any way to create a visual table like this. 
I tried using SVG but the size of image is very small 

Surya9_4-1622117731860.png

 





 

5 REPLIES 5
Anonymous
Not applicable

Hi @Anonymous 

You can change the size for the visual in Format Settings and change the size for text in Grid .

Ailsa-msft_0-1622531378253.png

Ailsa-msft_1-1622531378257.png

 

Best Regards

Community Support Team _ Ailsa Tao

 

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

Anonymous
Not applicable

@Surya , you can use the usual table and set the style to minimal. I think you are asking a visual suggestion and not for calculation. Please let me know if you need any help on that.

 

Thanks

Anonymous
Not applicable

I am asking for calculation and visual both becaue 
1Q1 - 1Q4 is the measures i had created for table 1 and 
2Q1 - 2Q4 is the measure for table 2 
so when i plot this seperately for table 1 and table 2 its showing the values
but i am confused how to calculate Q1 - Q4 in such a way that for table 1 it show the values of measures like

Surya9_0-1622119824127.png

 



Anonymous
Not applicable

And i had created the table using svg which shows the values based on filter but the problem is its size is to small, is there any visual that i can use to display the measure image url.

amitchandak
Super User
Super User

@Anonymous , Make sure 1st column name is same and merge two table,

It will three column having data in different rows

 

Create a new column from first column

 

Power query

Qtr = Text.End([Period],2)

 

DAX

Qtr = Right([Period],2)

 

In Visual this new column with other two

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.