Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
My chart and table behave okay when i select year=2021
Notice that left side the line chart display 2 dot is correct because it is 2021 Jan , only 1 month data.
But when i select year=2020 , the table able display sales and target amount. But then the line chart
display Null.
Note that right side the table , it can display both sales and target amount from jan till dec 2020.
Note :- during Dec 2020 , the left hand side chart working fine , it can display 2 line one is sales another is target line.
Hope some one can share with me why ?
Paul
Solved! Go to Solution.
Hi @Paulyeo11 ,
Please open Filters pane and clear the visual level filter "Year is 2021" for the line chart:
Best Regards
@Paulyeo11 , Can you check the file again. I see only one row for sales data(Table). And Sales is null other than 2020 one row.
Hi All
Thank you for all your help .
Paul Yeo
Hi All
Can some one advise me why line chart YTD when switch to year=2020 , it not display any line ? where go wrong ?
Paul
Hi @Paulyeo11 ,
Please open Filters pane and clear the visual level filter "Year is 2021" for the line chart:
Best Regards
Hi Ying
Thank you very much it work fine now.
Paul
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |