Conditionals formatting based on a column in the same visualization table

[mhablas426]

Guys,
I want to make conditional formatting based on column number (3) for the below table using DAX:
the values of column num (2) will appear in red if they exceed the values in front of it in column num (3), and they will be displayed in green if they do not exceed.
And please How can I apply this Dax to the table?
Thanks a lot
Table

[mhablas426]

It's a visualization table, not an data or regular table and I used the below measure to build it

Fuel Current Month Q =

CALCULATE(

    SUM('BI Fuel Issue'[Fuel Day Quantity])+SUM('BI Fuel Issue'[Fuel Night Quantity]),

    MONTH('F Dim Date'[Date])=MONTH(TODAY()),

    YEAR('F Dim Date'[Date])=YEAR(TODAY())

)

 so the question now How can I do the above measure as a table so can apply your answer to it

[bhanu_gautam]

@mhablas426 , First create a measure as per columns in your table

ColorMeasure =
IF(
[Fuel Current Month Q] > [SomeOtherMeasure], -- Replace [SomeOtherMeasure] with the actual measure or column you want to compare against
"Red",
"Green"
)

Then

1.Go to the Report view.
2.Add a table visual to the report and include the columns you want to display.
3.Select the table visual.
4.Go to the Format pane (paint roller icon).
5.Expand the Conditional formatting section.
6.Click on the drop-down arrow next to the column you want to format (e.g., Fuel Current Month Q) and select Background color or Font color.
7.In the Conditional formatting window:
Set the Format by option to Field value.
8.Set the Based on field option to the measure you created (ColorMeasure).
Click OK to apply the conditional formatting.

[mhablas426]

Thanks for your reply and your time, but I want first to convert this visualization table to a data table, a regular table!! How can I do that?
thank you again

[bhanu_gautam]

@mhablas426 , Are you taking columns from different sources in this visualization?

[mhablas426]

yes, kindly see the snapshot 

[bhanu_gautam]

There are two ways you can do that first go to power query and use merge queries as new option and combined table 1 and 2 first on the basis of column on which relation is created then do it similarly for 3 rd table or use DAX to create new column

CombinedTable =
SELECTCOLUMNS(
NATURALINNERJOIN(
NATURALINNERJOIN(Table1, Table2),
Table3
),
"Column1", Table1[Column1],

Only if they share common key
"Column2", Table2[Column2],
"Column3", Table3[Column3]
)

[mhablas426]

How can i share with you the PBIX file here?

[bhanu_gautam]

You could upload the file to OneDrive / Google Drive / DropBox and share the link here.

[mhablas426]

https://drive.google.com/file/d/1_qfWcbu27a394i1vTdpSVk-XLCrGhdip/view?usp=drive_link 

[bhanu_gautam · Accepted solution]

PFA , PBIX with table

[mhablas426]

Many thanks to you. I appreciate your help  🙏

[bhanu_gautam]

@mhablas426 , You can create a simple DAX for this

Column2Color =
IF(
SELECTEDVALUE('YourTable'[Column2]) > SELECTEDVALUE('YourTable'[Column3]),
"Red",
"Green"
)

Select the Table Visual: Click on the table visual where you want to apply the conditional formatting.

Open Conditional Formatting Options:

Go to the Format pane.
Expand the Conditional formatting section.
Click on the fx button next to the Font color option for the column you want to format (Column 2 in this case).
Set Up Conditional Formatting:

In the Conditional formatting window, select Field value under the Format by dropdown.
In the Based on field dropdown, select the measure you created (Column2Color).
Apply the Formatting: Click OK to apply the conditional formatting.