Another Conditional Formatting In A Table Not Showing

[Anonymous]

Hello,

I saw many posts regrading this, but still couldn't find the solution to my issue.

On the bottom you can find my measures. All of them are formatted as a decimal number. I want to have a conditional formatting icon in my table that will show various arrows.

Next, I have two tables:

- One of them is showing Period | NRM vPY and in this table the icons are visible.

- Second one if showing just NRM vPY and in this table the icon is not visible.

How can I make the second table showing the icons as well?

NRM_ACT =
VAR MaxPeriod = calculate(max('HFM BAR Data Pull'[Period]),'HFM BAR Data Pull'[Value]<>0)
return
calculate(sum('HFM BAR Data Pull'[Value]),'HFM BAR Data Pull'[Metric]="NRM P&L IMPACT",'HFM BAR Data Pull'[Period]=MaxPeriod)

NRM_PM =
var MaxDate01 = calculate(max('HFM BAR Data Pull'[Period]),'HFM BAR Data Pull'[Value]<>0)
var MaxDate02 = calculate(max('HFM BAR Data Pull'[Period]),'HFM BAR Data Pull'[Period]<MaxDate01)
RETURN
calculate(sum('HFM BAR Data Pull'[Value]),'HFM BAR Data Pull'[Metric]="NRM P&L IMPACT",PARALLELPERIOD('HFM BAR Data Pull'[Period],-1,MONTH),'HFM BAR Data Pull'[Period]=MaxDate02)

NRM_vPM = [NRM_ACT]-[NRM_PM]

Sample Data:

Business	Metric	Value	Period (Date Format)	Scenario	MonthName	Year
Sweden	NRM P&L IMPACT	0.01	08/01/2019	Actual	August	2019
Sweden	NRM P&L IMPACT	0.03	07/01/2019	Actual	July	2019
Sweden	NRM P&L IMPACT	0.06	06/01/2019	Actual	June	2019
Sweden	NRM P&L IMPACT	0.08	05/01/2019	Actual	May	2019
Sweden	NRM P&L IMPACT	-0.04	12/01/2019	Actual	December	2019
Sweden	NRM P&L IMPACT	-0.09	11/01/2019	Actual	November	2019
Sweden	NRM P&L IMPACT	0.02	10/01/2019	Actual	October	2019

[v-yuta-msft]

@Anonymous ,

You can change the target field in the conditional formatting section as below:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yuta-msft 

Sure. However I want this arrow to be visible in the small table that I have pasted above (the one that looks like a card and is showing a value equal to 0.10).

[v-yuta-msft · Accepted solution]

@Anonymous ,

I'm afraid this can't be achieved. To make conditional formatting work, you need to add at least one column to the table visual. In the small table visual there's only one aggregation value, no rows exist so conditional formatting couldn't work.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Ok, it helps. If so, I can do some changes and add an extra column.

thank you 🙂

[v-yuta-msft]

@Anonymous ,

So have you applied the icon conditional formatting in the second table? Could you share sample data of the two tables and give more details about your requirement?

Regards,

Jimmy Tao

[Anonymous]

@v-yuta-msft 

Thanks for the reply. I have adjusted my first post. It should be more clear now. I have only one table in this project.

[Greg_Deckler]

Very difficult to say, would need to be able to replicate. You are talking about 2 table visualizations or 2 tables in the data model? What fields are in the tables? Can you post sample data that can be used to replicate the issue? 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/38490

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Anonymous]

@Greg_Deckler 

I have edited my first post, sorry for that. I have added a sample data. Please note that I also do have similiar information, but for other periods (2018-2020).

You can also see that in the table, conditional formatting of vPM is working well (icons do appear). However, in the card above ("NRM vPM"), the icons do not show up.