topic Print a symbol whether the value is Significant or not in DAX Commands and Tips

Print a symbol whether the value is Significant or not

SK87 — Mon, 26 Dec 2022 06:26:30 GMT

Hi All,

I have build the measure where I got the p-value but I am not able to print the same in required format. I want to show the upward/downward arrow based on two filters one is year filter other one is category filter.

I have a bar chart where I have already comparing two years values of technology based on category split. x-axis - Category (in 5) then Bottom two box values of tech in Y-axis and in legends Year.

Now need to show the arrow if P-value is >=0.005 then upward arrow and if less than 0.005 then downward arrow based on Year and category filter.
Kindly suggest
amitchandak

Re: Print a symbol whether the value is Significant or not

amitchandak — Mon, 26 Dec 2022 07:01:17 GMT

SK87 , Based on what I got, You need have custom label using calculation group and unichar

Change Data labels
https://www.youtube.com/watch?v=un4PkoGF3YM

Custom label
https://www.youtube.com/watch?v=IH4bcHhxunw

Re: Print a symbol whether the value is Significant or not

SK87 — Mon, 26 Dec 2022 11:10:04 GMT

amitchandak
Thanks for your response.
But I want to print a symbol based on filter of year selected and categories. In bar charts they are splitted into 4. The video you had shared doesn't resolved my problem.
Incase you have any other way kindly let me know.

Re: Print a symbol whether the value is Significant or not

SK87 — Tue, 27 Dec 2022 09:36:21 GMT

tamerj1 AbbasG FreemanZ
It would be great if anyone of you could help on this