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.
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
Solved! Go to 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.
@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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |