Why Am I Not able to Duplicate Visual with Different Data

Hi cpatte7372 ,

This happens because the conditional formatting is tied specifically to the Sales field. When you duplicate the table, remove the Sales field, and replace it with the NumberOfPolicies field, the conditional formatting is removed as well. That’s because it was created for the Sales field and doesn’t automatically apply to other fields.

Think of it like this:
Imagine you have a spreadsheet where the Sales column is highlighted with colors based on the values. If you delete that column and add a new one for NumberOfPolicies, the colors won’t magically appear in the new column because the formatting was set up only for the Sales column.

This is normal behavior and makes sense because conditional formatting is field-specific. To fix it, you’ll need to reapply the conditional formatting for the NumberOfPolicies field.

cpatte7372 I haved fixed and atatched the pbix. Please check PowerBIF.pbix

Did I answer your question ? Mark this post as a solution.

Thanks,

Jai

Thank you danextian, the actual showing me worked for me. Cheers mate