Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Prem Guru]

Hello,
I have below chart, where we have not applied any Slicer selection. Y axis display the columns and X axis display the Line.

Issue is when I filter the slicer by “A”, I can see same value of “A” in the line and column (see below)

What will be best approach, if both the Column and line values are same, the line and their data values should disappear. Only the bars should be visible.
Any ideas. Thanks!

——————————
Prem Guru
——————————

[Tomas Torp]

Does it work if you replace the old, insufficient line measure with the new and improved line measure?

New and Improved Line Measure =
IF (
    NOT ( HASONEVALUE ( TableName[Business] ) ),
    [Old Insufficient Line Measure]
)?

——————————
Tomas
——————————
——————————————-

[Prem Guru]

,

Do you mean creating a new measure? If yes, where do we place this measure?

My Line Axis is just total of A and B.

My Apologize! not too expert in playing with DAX 🙁

——————————
Prem Guru
——————————
——————————————-

[Tomas Torp]

No worries, in my suggestion above you replace the old measure for the line with the new one, but you will have to keep the old one since it is referenced. If you have no need to keep the old one, you could instead rewrite the line measure like this:

Line Measure =
IF (
    NOT ( HASONEVALUE ( TableName[Business] ) ),
    [Measure A] + [Measure B]
)??

——————————
Tomas
——————————
——————————————-

[Prem Guru]

– Perfect! Most Appreciated. You made my day.

Applied a new measure as per your last response and was able to fix around 5 of my charts.

Thank You! once again for your expertise advise.?

——————————
Prem Guru
——————————
——————————————-