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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Surya9
Helper V
Helper V

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
v-yetao1-msft
Community Support
Community Support

Hi @Surya9 

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

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

 



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

@Surya9 , 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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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