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.
Hello guys!
I have to calculate trend based on last 3 months and then (if possible) display that trend as arrow (red, orange, black) in table.
My data looks like this:
Supplier | Date | Defect Type |
A | 01.11.2020 | 4 |
B | 01.10.2020 | 3 |
B | 02.10.2020 | 2 |
B | 03.10.2020 | 1 |
B | 01.11.2020 | 1 |
B | 02.11.2020 | 1 |
B | 01.12.2020 | 4 |
C | 01.11.2020 | 5 |
and i want to achive sth like this:
btw - how to add pbix file here?
Solved! Go to Solution.
Hi, @mr_oli
You can try to create a summarize calculated table :
New Table =
SUMMARIZE (
'Table',
'date'[Date],
'date'[Date].[Year],
'date'[Date].[Month],
'date'[Date].[MonthNo],
'Table'[Supplier],
"Count Defect Type", COUNT ( 'Table'[Defect Type] )
)
Then create a calculated column applied to the icon conditional formatting:
Percentage =
IF (
ISBLANK ( 'New Table'[Previous Count Defect Type] ),
BLANK (),
'New Table'[Count Defect Type] / 'New Table'[Previous Count Defect Type]
)
Please check my sample pbix for more details.
If it doesn't meet your requirement, please let me know .You can also upload your sample file to Onedrive for Bussiness then share the link here.
Best Regards,
Community Support Team _ Eason
Hi, @mr_oli
You can try to create a summarize calculated table :
New Table =
SUMMARIZE (
'Table',
'date'[Date],
'date'[Date].[Year],
'date'[Date].[Month],
'date'[Date].[MonthNo],
'Table'[Supplier],
"Count Defect Type", COUNT ( 'Table'[Defect Type] )
)
Then create a calculated column applied to the icon conditional formatting:
Percentage =
IF (
ISBLANK ( 'New Table'[Previous Count Defect Type] ),
BLANK (),
'New Table'[Count Defect Type] / 'New Table'[Previous Count Defect Type]
)
Please check my sample pbix for more details.
If it doesn't meet your requirement, please let me know .You can also upload your sample file to Onedrive for Bussiness then share the link here.
Best Regards,
Community Support Team _ Eason
@mr_oli Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@mr_oli , what is the basis of arrow and color. Month vs month. Three month avg vs current month , three vas last three ?
thank you for you answer
I discovered that comparing 3 months wont work, so I need to compare last month versus -2 month from current date
I think that I will use solution from this link:
https://community.powerbi.com/t5/Desktop/Unable-to-display-trend-arrows-in-table-visual/td-p/138572
But the problem is that I can't create a measure to sum number of defects from previous date range (in my example whole month) which will be looking for current date.
I tried something like this:
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
85 | |
65 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |