Forum Discussion
Advocate IIConditionals formatting based on a column in the same visualization table
PFA , PBIX with table
Super Usermhablas426 , 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.
Advocate IIThanks 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]
)