Forum Discussion

JKTUATH's avatar
JKTUATH
Frequent Visitor
3 years ago

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...
General Comment
Need Help
Tips and Tricks
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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

JKTUATH's avatar
JKTUATH
Frequent Visitor
3 years ago

Hello,

 

Thanks for your help.

 

No, I'm not using two date tables.

I created a custom date hierarchy within Bravo.

Please see below:

 

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?