cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chris_G_TP
Regular Visitor

Compare the value of a column in one visual to a column in another visual

Hello all,

 

I am trying to compare the value of a column in one visual to a column in another visual.  The underlying table is the same for both visuals but using separate queries, one for each visual.  The Date Slicer is linked to the first visual and the Date_2 slicer is linked to the second.  When I sunbtract vol% from vol_2% I get 0, some research showed me that even though the Vol% is a calculated column or a variable defined in the first visual, the Date2 slicer is contolling the first table. I've tried turning relationship on and off with no change in results, also tried related does not support computed columns in the visual

 

So my question is this, how can I pull the values from the Date Slicer to be used in a query by the Date_2 Visual?  I've tried

End_Date = CALCULATE(MAX(CALL_TYPE_COMBINED[Date]),ALLSELECTED(CALL_TYPE_COMBINED)). However that
references the table and not the slicer and I end up with the same results.
 
Any insight on how to solve this would be greately apreciated.

 

Slicer Reference.jpg

1 ACCEPTED SOLUTION

I tried setting up an unrelated table using the dates from the primary table, however that did not work.  I resolved my issue by using one visual then changing from a computed column to a measure.  I then used CALCULATE with it's own set of filters to retrive the month to date data.Slicer Reference - Solution.jpg

View solution in original post

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@Chris_G_TP , Need to understand how you have done it. If volume1 and volume2 have same formula(same table) other than date range then one of them has to use independent date table for range

 

refer my video example

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

 

 

or

 Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I tried setting up an unrelated table using the dates from the primary table, however that did not work.  I resolved my issue by using one visual then changing from a computed column to a measure.  I then used CALCULATE with it's own set of filters to retrive the month to date data.Slicer Reference - Solution.jpg

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors