Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Community,
I have two question.
i.) If number <=4 , return false . More than it will be true. I get the Dax. But I do not want the blank value in DiffDay return anything. But this DAX return false to the blank value.
Solved! Go to Solution.
@NickProp28 , I forgot My own suggested solution. Check now.
@NickProp28 , the formula seems fine. It is column check what value you have taken sum/min/max. Because on the color it will take aggregation.
You can also try a color measure and use that using "Field Value"
if it is a column
Color = IF(sum(SubBV[DiffDay])<=4, "Green", "Red")
It is measure
Color = IF([DiffDay]<=4, "Green", "Red")
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/dax-unichar-function-power-bi/
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Dear @amitchandak ,
Thanks for ur prompt response. Yes, i able to get the correct colour after change from sum to min.
But do you have any idea on my another question?
If Datediff less than or equal to 4 day will return false, while more than will be true.
And if datediff is blank, i do not want it to return anything. Just remain as blank.
But this DAX
@NickProp28 , for blank you can try like
Switch(true(),
isblank(SubBV[DiffDay]), blank(),
SubBV[DiffDay]<=4, "False"
SubBV[DiffDay]>=5 ,"True"
blank())
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Dear @amitchandak ,
I follow your code, but encounter error.
Here the pbix : https://ufile.io/sd52jjtx
Please take a look on the dataset.
Thanks for your help.
@NickProp28 , I think is happening because there multiple values job ID. so they adding up. I plotted it with unsummarized option and it worked
Please find the attached file after signature
Dear @amitchandak ,
In you pbix,
Datediff still fall into 'false' categories. I would want if datediff is blank, in the True/false column remain blank.
Is it possible to do it? I tried many ways but still categories in 'false'.
Appreciate your help.
@NickProp28 , I forgot My own suggested solution. Check now.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |