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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
JKTUATH
Frequent Visitor

Figure comparison [ Dataset comparison ]

Hi Everyone,

 

I'm trying to compare year/year, month/month e.t.c figures.

I have tried using the clustered bar chart and the tornado visual to display these figures but I'm unsure where to adjust accordingly.

I have set a filter for the supplier based on the number of works they do but can only get it to display for one table and not two combined ( I have two datasets - 2021 v 2022 )

 

Capture.PNG

 

 

Below I have tried adding the number of work orders from the older dataset but I'm only getting the total ( 8740 ).

Essentially Powerbi is comparing all suppliers based on work V total works in a different data set.

 

c1.PNG

 

 

 

I want to compare both datasets dynamically.

I tried also adding the suppliers from the other dataset but no luck.

 

What I have tried so far :

- Creating a relationship between the columns ( but there were some suppliers we used last year that are not present and vice versa)

- Use both suppliers and work order fields on the visual filter ( No luck )

 

Looking for some workaround, Dax expression or my logic is flawed?

 

Please and thank you 🙂

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @JKTUATH 

 

Do you have two years' data in two different tables? If so you need to use two measures to calculate the results from two tables separately. Or you can calculate results into a new calculated table in advance. Then add a legend field to the tornado visual instead of using two measures. And I guess you probably need to use a year/month slicer to switch the year or month for comparison. 

 

Here is a thread that may be helpful: Population pyramid Tornado chart with slicer for y... - Microsoft Power BI Community

 

If this doesn't help, can you please provide some dummy data to show the data table you have? We can try to think of detailed solutions based on the data then. 

 

Best Regards,
Community Support Team _ Jing

Hello,

 

Thanks for your help.

 

No, I'm not using two date tables.

I created a custom date hierarchy within Bravo.

Please see below:

F1.PNGF2.PNGF3.PNG

 

I have two separate tables for 2022 & 2021 respectively.

Both tables have the same columns and naming conventions from the portal I have extracted them from.

 

I'm not sure how I can implement a calculated column in order to compare total values from each dataset based on the suppliers.

 

Would creating a measure be recommended if I were to import another source in the future?

JKTUATH
Frequent Visitor

The two visuals below are charts with the separate datasets [ 2021 v 2022 ] which is representing the figures correctly, but I'm looking to have both figure side by side hence the tornado visual.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.