Forum Discussion
sravan872
1 year agoFrequent Visitor
Need help in Line Chart
I have a table with Fund Code, Tracking Error, Aladdin Tracking, Effective Date Error etc and a caledar table joined with effective date in Fund Table. I am representing AVERAGE(Aladdin Tracking erro...
OwenAuger
1 year agoSuper User
Hi sravan872
This is very similar to the problem on another thread with the solution post here with some instructions on setting it up.
The basic idea is to create a special field parameter to use as the Legend field on the visual.
In your case, the field parameter would include two items: Fund Code & a BLANK item.
You then create a measure that detects whether Fund Code is filtered, and allows the correct field parameter item to be selected.
- If Fund Code is filtered then Legend = Fund Code
- If Fund Code is not filtered then Legend = BLANK
I have re-attached the same demo PBIX included on the solution linked above (ISO Code is comparable to your Fund Code in this model).
Are you able to get something like this working?
Please post back with specifics on your model or a sanitised PBIX if you can.
Regards