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
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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.