Forum Discussion

KoenGerrits's avatar
KoenGerrits
New Member
2 years ago

Select specific rows based on calculation

Hi Power BI experts,

 

I am quite new to Power BI and I cannot figure out how to visualise this properly.

I have the following table:

TemperatureDescription1Description2Description3
24NormalNormalNormal
25AlarmingAlarmingNormal
26AlarmingAlarmingNormal
27CrisisCrisisAlarming

For simplicity lets assume that the descriptions are from 3 different persons

I made a calculation about the maximum temperature for the coming two weeks, and I want to visualise the matching descriptions. So say for example that the max temperature will be 26, I want to see the following:

 

Description1Description2Description3
Alarming AlarmingNormal

 

Can somebody help me out?

 

Thanks in advance!

1 Reply

  • I should add that I work with DirectQuery, which makes me unable to create new tables.