Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I try to set chart with filter for field = Show_3_YR = 1 for PBI file name =PBI_V18
After that i create a bookmark , and save bookmark at button. and it work fine.
The issue happen when i try to save file as PBI_BACKUP
And i notice that filter for field = SHOW_3_YR , no more working. so the chart display wrong value.
Can some one advise me where go wrong ?
Paul
Solved! Go to Solution.
You will need to change the column name to INVC[Last Sales].I have edited my reply to reflect the same.
Hi @admin11 ,
Can you trying creating the measure like:
difference =
IF (
DATEDIFF ( NOT ( ISBLANK ( <YourColumnname> ) ), TODAY (), DAY ) > 3 * 365,
1,
0
)
See if it works
Hi PC2790
i get error below :-
You will need to change the column name to INVC[Last Sales].I have edited my reply to reflect the same.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |