The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Team ,
i want to highlight the max vlaue in Table visual.I have data as below .
I dont have seperate column for Count of injection Category . I used Count of in Table visual.
I want to find the max value in count of inject category and add a new column with color and i should use it in conditional formatting.
Help me to get the max value in red color and others in green in next new column
Solved! Go to Solution.
hello @Ayappan
step 1
create count measure
Count = COUNTROWS('Table')
step 2 create the max measure
max of = MAXX(ALLSELECTED('Table'[Catgeory]),[Count])
step 3 create the hightlight measure
Highlight =
VAR cond =
IF([Count] = [max of],1,0)
RETURN
IF(cond = 1 , "Red","Green")
step 4 press on your table and go to cell elemnt in the format panel
step 5 select the column you want to highlight
step 6 choose background color
step 7 press fx and select field value
step 8
use the highlight measure and click done
results
please leave a thumbs up and accept as solution if i helped you answer your question
hello i did a simple dataset
i created a measure Total which is = CALCULATE(SUM('Table'[Total]))
now i added them to a table
next you need to create a measur ethat will identify what is your max and minimum
Max Value =
VAR _m = MAXX(ALLSELECTED('Table'),[Total Is])
VAR _con = IF(_m=[Total Is],1,0)
RETURN
IF(_con = 1 , "Red","Green")
next, press on your table to format it ,
go to cell ement part of the format and toggle on background color
choose field value and select your measure
end result
if i helped you solve your question , please consider liking and accepting as solution to better help others
Hi @eliasayyy
Thanks for you replay . I Dont have Total column in my Database .
I have only 1 Column and i am using the count of the 1st colimn in Table visual .
Example : in you case i have only Month Column . In my database multiple records has jan feb ... so i am using the count of as 2nd column . I am not able to use the count in the formula you gave .
Let me know how to use it .
Aagin Thanks
Can you share please sample data as well as your measure
Sample Record from Table
Requirements | A |
Others | B |
Design/Code | C |
Training | A |
Others | B |
Requirements | C |
Others | A |
Requirements | B |
Others | C |
Design/Code | A |
Design/Code | B |
Design/Code | C |
Design/Code | A |
Design/Code | B |
Design/Code | C |
Requirements | A |
Requirements | B |
Requirements | C |
Training | A |
Others | B |
In Power Bi I had used
Column 1 and Count of Column 1
I did't use any measure
Thanks
hello @Ayappan
step 1
create count measure
Count = COUNTROWS('Table')
step 2 create the max measure
max of = MAXX(ALLSELECTED('Table'[Catgeory]),[Count])
step 3 create the hightlight measure
Highlight =
VAR cond =
IF([Count] = [max of],1,0)
RETURN
IF(cond = 1 , "Red","Green")
step 4 press on your table and go to cell elemnt in the format panel
step 5 select the column you want to highlight
step 6 choose background color
step 7 press fx and select field value
step 8
use the highlight measure and click done
results
please leave a thumbs up and accept as solution if i helped you answer your question
@eliasayyy Thanks a lot .It helped me is this same applies for Matrix Table also ?
Yes the same applies to matrix tables
Hi @eliasayyy
In matrix i am facing some problem .Same measures i had used. Its not wokring as expected .
1st measure
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
33 | |
20 | |
16 | |
15 |
User | Count |
---|---|
55 | |
50 | |
36 | |
35 | |
28 |