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 team....
I Have S_SPL_QMR_DO_WEEKLY_2024_F table in power bi. In that table tour request numbers, week number, departure year, Qt exclude flag, columns are there. I want to showthe distinct Tour count for each week in line chart. but For that weeks the the tour count should be count separatly from Current week to Last 6 weeks counts, in that line chart week numbers should be change weekly when data is refreshed as schedule refresh.For that distinct counts the filter conditions are 'S_SPL_QMR_DO_WEEKLY_2024_F'[DEPARTURE_YEAR]=YEAR(TODAY()) , 'S_SPL_QMR_DO_WEEKLY_2024_F'[QT_EXCLUDE_FLG]=0.
I want to show like this in power bi line chart. I have used this DAX measure
Based on your description and screenshots, I can't understand your needs very well. Can you provide your PBIX file? So that I can help you better. Please remove any sensitive data in advance.
Regards,
Nono Chen
User | Count |
---|---|
66 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |