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 folks,
I have the following table. I currently have sales by weeks and % change for all the weeks shown.
But I would like to show the sales for all weeks but the % change for only the last week.
I believe I could hide the older columns if the data was static but difficult to do so as the week progresses.
Categories | 202415 | 202414 | 202413 | 202412 | 202411 | ||||
Sales | %Change | Sales | %Change | Sales | %Change | Sales | %Change | Sales | |
Product 1 | 50 | 56% | 32 | ||||||
Product 2 | 62 | 14% | 54 | ||||||
Product 3 | 30 | 30% | 23 |
Any suggestion to resolve this issue ?
Thanks in advance!
HI @Newuser20240515,
You can extract the fact table latest date to store in variable and use this as condition to compare with current date value from matrix column field.
Then you can show the result if current date is the latest date and replace the other result to blank. (power bi visuals will auto hide the fields if whole row/column only existed blank values)
Regards,
Xiaoxin Sheng
Hi @Newuser20240515 ,
Can you please share a some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |