Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hello
I want to synchronize 2 graphic box with a general timestamp filter.
My data are organised like that : timestamp / parameter_name / value.
- On TOP graphic, I have data with parameter_name = Current temperature, Effective temperature setpoint, netatmo_temperature_haut and Temperature probe calibration offset from feb-02 to March-31
- On Bottom graphic, I have data with parameter_name = Taux de marche from feb-19 to March-28
Graphics are correctly syncronized because I use X axis parameter : start = fx( timestamp min) , end =fx(timestamp max),
with :
-----------------------------------------------------------------------------
But, when I change the timestamp general filter (from feb-2 ...) , graphics are not synchronized !!
Can you help me ?
Solved! Go to Solution.
@Patrick_Pontor , try like
min = var _1= CALCULATE(MIN(rawdevicestate_follow[timestamp]),REMOVEFILTERS((rawdevicestate_follow[parameter_name]))) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
max= var _1= CALCULATE(Max(rawdevicestate_follow[timestamp]),REMOVEFILTERS((rawdevicestate_follow[parameter_name]))) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
Thanks !!! It's OK !!
@Patrick_Pontor , try like
min = var _1= CALCULATE(MIN(rawdevicestate_follow[timestamp]),REMOVEFILTERS((rawdevicestate_follow[parameter_name]))) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
max= var _1= CALCULATE(Max(rawdevicestate_follow[timestamp]),REMOVEFILTERS((rawdevicestate_follow[parameter_name]))) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 49 | |
| 44 | |
| 41 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 71 | |
| 66 | |
| 33 | |
| 32 | |
| 32 |