Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Table comparison between current and last year

I am using the table to compare the current month and the same month last year. Here is the DAX I used for both columns Actual hours = sum(submissionCycleTime[# of actual hours]) LY Submissio...

Need Help

amitchandak
5 years ago
Anonymous , you can create a color measure like

Switch(true(),
[change%] <.16 , "Red" ,
[change%] <.18 , "yellow" ,
"green"
)

The same way you can create a unichar measure and combine both

refer example

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

amitchandak

Super User

5 years ago

Anonymous , you can create a color measure like

Switch(true(),
[change%] <.16 , "Red" ,
[change%] <.18 , "yellow" ,
"green"
)

The same way you can create a unichar measure and combine both

refer example

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

Anonymous

Not applicable

5 years ago

Thank you

Forum Discussion

Table comparison between current and last year

Related content

Comparison Chart

BI Tools Comparison

Comparison Table

Comparison matrix table

Microsoft Fabric and Databricks integration/comparison