Why does my Card show -- when duplicated but original Card is able to filter correctly.

[Anonymous]

Hello PowerBI community, 

I have an issue whereby the original card is able to filter correctly.

However, when the card is duplicated, the duplicated card shows a -- instead of the same value.

Why is the original card able to show the correct value but the duplicated card is unable to show any value when filtered?

Thank you!

[v-veshwara-msft · Accepted solution]

Hi @Anonymous ,
Thanks for using Microsoft fabric Community,
Since the original card correctly reflects filtered values, but any new or duplicated card displays -- even after applying a DAX like the one suggested, it’s likely the issue is  rather related to filter context or visual-specific settings.
Here are a few steps you can try:

1. Compare the visual-level filters applied to the original and the new card. Even small differences in filters can impact the measure’s behavior. Select each card one by one, open the Filters pane, and take a close look under "Visual-level filters" to make sure they’re exactly the same.
   
   

2. Check the slicer interactions. Sometimes when you add or duplicate a visual, it doesn’t automatically pick up slicer filters. Click on Format > Edit Interactions, then select each slicer or filter on the page, and make sure the new card has the filter icon enabled. If it’s turned off, it won’t respond to the slicer at all.
   
   

3. Review the data label and formatting settings. It’s possible that a rule is hiding the value on the new card. Select the card, go to the Format pane, then under Data label, check if there are any conditional formatting rules that might be preventing the value from showing, especially in blank or special cases.
   
   

4. As a quick test, try adding a Table visual using the same measure. Apply the same filters. If the values appear correctly in the table but not in the card, that confirms the issue is with how the card is interpreting the filter context, not the data itself.
   
   

5. Try using the SELECTEDVALUE() function within a temporary measure on both visuals to display filtered context values. This will help identify whether the filtering context is reaching the card as expected.
   
   
6. Try saving and reopening the report or republishing it, just in case there's a rendering or caching glitch in the duplicated visual.

If the issue still persists after trying these steps, feel free to share your .pbix file or a screenshot of both visuals with the filters applied. This will help us better understand the setup and reproduce the issue on our end for further investigation.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you.

[mdaatifraza5556]

Hi @Anonymous 

Can you please check once by creating a new card and adding that measure?

[Anonymous]

Hello @mdaatifraza5556,

I tried and it shows the same thing when filtered.

The original card is able to be filtered but the new card still shows -- .

[mdaatifraza5556]

Hi @Anonymous 
Can you please try this ?

ChairsTotal =
SWITCH(
        TRUE(),

       ISFILTERED('Budget Headcount Actual'[IPS_Label]) ||
      COUNTROWS(VALUES('Budget Headcount Actual'[SnD])) >= 2 && (
     "ALL SP" IN VALUES('Budget Headcount Actual'[SnD]) ||
     "ALL Depts" IN VALUES('Budget Headcount Actual'[SnD]) ||
     "ALL Schools" IN VALUES('Budget Headcount Actual'[SnD]) ||
     "HR+PODS" IN VALUES('Budget Headcount Actual'[SnD]) ||
     NOT(CONTAINSSTRING(SELECTEDVALUE('Budget Headcount Actual'[SnD]), "Cluster"))
),

SUMX(
     FILTER(
    'Budget Headcount Actual',
    'Budget Headcount Actual'[Date] IN VALUES('Budget Headcount Actual'[Date]) &&
    'Budget Headcount Actual'[SnD] IN VALUES('Budget Headcount Actual'[SnD]) &&
     NOT('Budget Headcount Actual'[SnD] IN {
    "ALL SP", "ALL Depts", "ALL Schools", "HR+PODS"
    }) &&
  NOT(CONTAINSSTRING('Budget Headcount Actual'[SnD], "Cluster"))
),

'Budget Headcount Actual'[Available]
),

NOT(ISFILTERED('Budget Headcount Actual'[SnD])) && NOT(ISFILTERED('Budget Headcount Actual'[Date])),
SUMX(
'Budget Headcount Actual',
'Budget Headcount Actual'[Available]
),

ISFILTERED('Budget Headcount Actual'[SnD]) && NOT(ISFILTERED('Budget Headcount Actual'[Date])),
SUMX(
FILTER(
'Budget Headcount Actual',
'Budget Headcount Actual'[SnD] IN VALUES('Budget Headcount Actual'[SnD])
),
'Budget Headcount Actual'[Available]
),

ISFILTERED('Budget Headcount Actual'[Date]) && ISFILTERED('Budget Headcount Actual'[SnD]),
CALCULATE(
SUM('Budget Headcount Actual'[Available]),
FILTER(
'Budget Headcount Actual',
'Budget Headcount Actual'[Date] IN VALUES('Budget Headcount Actual'[Date]) &&
'Budget Headcount Actual'[SnD] IN VALUES('Budget Headcount Actual'[SnD])
)
),

ISFILTERED('Budget Headcount Actual'[Date]),
SUMX(
FILTER(
'Budget Headcount Actual',
'Budget Headcount Actual'[Date] IN VALUES('Budget Headcount Actual'[Date])
),
'Budget Headcount Actual'[Available]
)
)

[Anonymous]

Hello @mdaatifraza5556 
I've tried your DAX formula but it seems the same issue persists. 

The original card is able to filter but the other card still shows --