User Profile
bhaskarpbi999
Helper V
Joined 2 years ago
User Widgets
Contributions
Re: Card Visual not showing correct values after excluding dimension column
Hi FBergamaschi, Thanks and kudos for your support. I have replied about the behavior of GRFlagM but i have seen yourolution solution post and i am expecting the same result after customer name is removed. Could you please share the test .pbix so that i can check it and see if it works fine with sclicer filter. Thanks in Advance for your immense support. Regards, Bhaskar2.8KViews0likes2CommentsRe: Card Visual not showing correct values after excluding dimension column
Hi FBergamaschi, I have created GR FLagM bco'z i cant use the measure logic IF([Rev cy] > [Rev Ly], 1, 0) and use it directly in slicer due to power BI feature restriction. I used GR FlagM measure and filtering it using GR flag slicer which is number column from Flag slicer table and specified the logic in the below formula. GR FlagM = VAR Test = IF([Rev cy] > [Rev Ly], 1, 0) RETURN IF(ISFILTERED('Flag Slicer'[Number]), IF((Test= SELECTEDVALUE('Flag Slicer'[Number])),1,0),0) When you select GR flag slicer value then only it will display data else no data. Thanks for your support and if there is a alternative way that would be really helpfull for this issue. Regards, Bhaskar2.8KViews0likes1CommentRe: Card Visual not showing correct values after excluding dimension column
Hi Bergamasch. I needs GR flagM measure as a slicer filter but we can"t use measure as a filter. So if I need to use GRFlagM in slicer I have defined that logic. But my client wants to filter and use RevDiff measure in charts with different dimensions but when use them like month wise and market segment wise not getting right numbers and I have issue to filter growing flag.. Thanks for your extreme support2.9KViews0likes10CommentsRe: Card Visual not showing correct values after excluding dimension column
Hi MasonMA, The logic used for GRFlagM is the below formula. GR FlagM = VAR Test = IF([Rev cy] > [Rev Ly], 1, 0) RETURN IF(ISFILTERED('Flag Slicer'[Number ]), IF((Test= SELECTEDVALUE('Flag Slicer'[Number ])),1,0),0) Regards, Bhaskar828Views0likes0CommentsRe: Card Visual not showing correct values after excluding dimension column
Hi MasonMA, I have implemented the suggested formula but some how it's not working. The issue when we ahve customer name with GR Flag slicer applied the value is 2169. After removing customer name the value is 1984 and GR flag slicer also not working Could you please help if i can modify formula to get the value for Rev CYand LY. I have prepeared .pbix file with sample data but some how unable to upload file. Regards, Bhaskar3KViews0likes3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.