Why Am I Not able to Duplicate Visual with Different Data

[cpatte7372]

Can someone please take a look at the PBIX and let me know why I'm not able to get the blue horizontal bars on the visual on the right, even though the visual on the right is a duplicate of the visual on the left.

The pbix can be located here

https://drive.google.com/file/d/1JBIx1pGe-jo-n3dfwdSKKVq4JKu0QcU8/view?usp=sharing

[cpatte7372]

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

[Jai-Rathinavel]

@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

[Bibiano_Geraldo]

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.

[danextian · Accepted solution]

Hi @cpatte7372 

I am able to add databars in your sample pbix.