Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
Im brand new to PowerBI. I have a very large data model with many sources that collects data over time. (Some parameters are at different time intervals).
I would like the value in each visual for 'temps1, temp2, temp3' to be the value corresponding to the 'Max' of another parameter from a different data set at the same time. I.e Display 7, 4, 6. (see below)
I would like to display the temperatures on either cards, or guage visuals that correspond to the time that the 'Cooling Load' is max over a selected time period.
Any ideas would be much appreciated!
Solved! Go to Solution.
Hi @Dave6547 ,
Please check the Pbix.
There might be some differeces with your table, if you don't have any Confidential Information, better to share your pbix to us.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Dave6547 ,
Have your problem be solved? Please consider accept the answer as a solution if it worked.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Dave6547 ,
Please refer to the following steps.
1# Create a measure as below.
Measure = CALCULATE(SELECTEDVALUE('Table'[Column1]),FILTER('Table','Table'[Column2]=MAX('Table'[Column2])))
2# Create a visual for dataset 1 and create a measure as below then add it to visual level flter.
Measure 2 = IF(SELECTEDVALUE('Table (2)'[Column1])=[Measure],1,BLANK())
Result would be shown as below.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jay,
Thanks for the response.
I am still having a bit of trouble.
The first measure you described does get me to the time of day that the max occurs.
The second measure comes up as blank when I put it into a visual, and the filter dropdowns for measure 2 do not allow me to interact with them and set to 'is not blank'
This is what I have for the measures.
Also,
I don't want to display all of the visuals as a table, will this method work with guages as well?
Appreciate your help.
Cheers!
Hi @Dave6547 ,
Please check the Pbix.
There might be some differeces with your table, if you don't have any Confidential Information, better to share your pbix to us.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |