Forum Discussion
Power Bi Visual matrix to highlight the given information
Hi Hassa0213 ,
I think this is pretty close to what you want:
Maybe you can think about it.
Create a new column:
Highest Stage achived = IF( 'Table'[Inovation Stage] = MINX(FILTER('Table','Table'[Company] = EARLIER('Table'[Company])),'Table'[Inovation Stage]), MAXX(FILTER('Table','Table'[Company] = EARLIER('Table'[Company])),'Table'[Inovation Stage]))Then create a matrix:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHassa0213 , Not very clear
if you want to show max at the company level
maxx(Values(Table[Stage]), calculate(Sum(Table[Ticket])) )
If you want find max at company level and highlight
max 1 = calculate(maxx(Values(Table[Stage]), calculate(Sum(Table[Ticket])) ), allselected(Table[Company]))
Then you can have color measure and use that in conditional formatting using field value option
If([Max 1] = Sum(Table[ticket]) , "Green", "White")
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
Thanks, Ill try this and see.
Hi Sorry the question was not clear. There is 3 columns company name, innovation stage and ticket ID. The user will submit the ticket ID for each company for each innovation stage. The innovation stages for each company is ‘1.Stage’ , ‘2.Stage’, ‘3.Stage’, ‘4. Stage’ . I want to show the user submitted current highest (max) innovation stage at the company level.
And also show the ticket ID without summing it in another column.
Please let me know how to get a similar visual to this in a matrix or in any table view? Thanks
I want an output table information as shown below. Thanks a lot.
Company Name Highest Stage achived Ticket ID Company A 3.stage 1.stage 101 2.stage 103 3.stage 104 Company B 4.stage 1.stage 102 2.stage 105 3.stage 106 4.stage 107
