Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional column PowerBI

So basically first column you see with the time values, but in format as a whole number. Second column should be the drive time norm that should not be exceeded. Now the third column should do the fo...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

@v-stephen-msft Many thanks for your help, one more thing: I created a custom column to return the actual time value if the time exceeds the norm and if it did not, then just return the actual time value, like shown below. If the Time column exceeds 4:30, then it shows difference, if not, it returns the actual time value.

However, i need to display it into the histogram and show the actual value below 4:30 or 4:30 in the green color and then if it exceeds it would add on the column and show it in red, something like that below. Any ideas what measure should be created?

Gediminas12_3-1600686610474.png

Gediminas12_2-1600686462035.png

Gediminas12_1-1600686444317.png

Gediminas12_0-1600686427862.png

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Because if you put the value of the time type in the Values of the histogram, there can only be two aggregation operations, Count and Count (Distinct), so I changed it to display the percentage of time.

 

1.Add an index column and create these calculated columns.

TIME = TIME(23,59,59)
Percentage = [klaipėda - radviliškis]/[TIME]
below 4:30 or 4:30 = IF([klaipėda - radviliškis]>[klaipėda - radviliškisNorma],[klaipėda - radviliškisNorma]/[TIME],[Percentage])
above 4:30 = [Percentage]-[below 4:30 or 4:30]

 

2.Create a Stacked column chart and a martix. Then combine them.

 

 

You can check more details from here.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.