Forum Discussion
Line and Legend highlight in Line chart
Memorable MemberHello SatyamPrajapati ,
You can use DAX to create a measure that returns values only for the selected product and blanks for others
Highlighted Total Qty =
IF(
SELECTEDVALUE('YourTable'[Product Name]) = SELECTEDVALUE('Product Name Slicer'[Product Name]),
SUM('YourTable'[Total Qty]), BLANK())
Replace the Total Qty measure in the Y-axis with the Highlighted Total Qty measure.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Hello dharmendars007 ,
what column should I use in place of 'Product Name Slicer'[Product Name] as Dax provided by you?
- dharmendars007
SatyamPrajapati
Machinery name Column, I assume that is what you are using in Visual.If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Machinery name column already replaced in left side of equal to, so what should i select right side to equal to? Same as left side?
SELECTEDVALUE('YourTable'[Product Name]) = SELECTEDVALUE('Product Name Slicer'[Product Name])
Machinery column selected in place of Yourtable [Product name], what should I select on right side?