Forum Discussion

bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
1 year ago
Solved

Card Visual not showing correct values after excluding dimension column

Hi ,   I have an issue with card visual where Rev Difference is not showing correct values after customer name is excluded from table visual.   Correct data       Incorrect data is disp...
Need Help
bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
1 year ago

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,
Bhaskar

 

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

Is this answer what you were looking for ?

 

https://community.fabric.microsoft.com/t5/Desktop/Card-Visual-not-showing-correct-values-after-excluding-dimension/m-p/4771949/highlight/true#M1421875

 

If it is, I can share the file so you check in detail

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI