Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I want to visualize the sales data with an indicative icon. The data looks like below
I want to visualize the data in the following format in a matrix table
I am aware that the icons can be added using the conditional formatting. However I'm unable to set the rule such that it compares the data with the previous day and show the icon(red down, green up). Please note I will sort the column in descending order in the matrix table to bring 4th May in first olumn followed by 3rd, 2nd and 1st.
Any idea how can I visualize the data in this way?
Thanks
Solved! Go to Solution.
Hi @subhendude
Thanks for the reply from @amitchandak , please allow me to provide another insight:
Create a calculated column as follow
Column =
VAR _earlier = 'Table'[Date]
VAR _earliersales = CALCULATE(SUM('Table'[Sales]), FILTER(ALLEXCEPT('Table', 'Table'[Items]), _earlier = [Date] + 1))
RETURN
[Sales] - _earliersales
Output:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @subhendude
Thanks for the reply from @amitchandak , please allow me to provide another insight:
Create a calculated column as follow
Column =
VAR _earlier = 'Table'[Date]
VAR _earliersales = CALCULATE(SUM('Table'[Sales]), FILTER(ALLEXCEPT('Table', 'Table'[Items]), _earlier = [Date] + 1))
RETURN
[Sales] - _earliersales
Output:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@subhendude , You can do this using measure with unichar icons, but those will measures and need use as another measure in table
/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)
/////Arrow Color , to be used in conditional formatting using field value option
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)
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/
UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50
@amitchandak thanks for the pointers. I would prefer to use the _change in the condition formatting and render the icon based on the rules.
I am unable to figure out [Net Sales YTD] and [Net Sales LYTD] measures based on my data provided below. How do I calcuclate them?
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |