Forum Discussion
matrix formation
hii
how can i arrange the data in a perfect matrix format.here the values are not arranged in perfect format of matrix.
5 Replies
What exactly do you mean by perfect format? Can you maybe make a simple example in excel and take a picture of it?
/ JYou will need to calculate HIT/MISS for both of your priorities in the same calculation. Are the priorities in different tables/columns?
/ J
Hi Anonymous ,
Not sure what is needed.
You can try this.
https://www.youtube.com/watch?v=58a2rIV2nYg
https://www.burningsuit.co.uk/blog/2020/03/power-bi-conditional-formatting/
Regards,
Harsh Nathani
Hi Anonymous ,
Not certain how it should arrange based on your picture. It looks like there is blank value in [PLI 4HR] field of MISS field, could you share more details about this for further discussion?
Sample file and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
