Excluding blank columns from a legend in a chart

[czarejka]

Hi,

I am trying to create a graph in Power BI with multiple bars and multiple lines, like this

Power Bi easily manages multiple bars but is struggling with lines. My data looks like this:

Date	fund	Share class	NAV	NAV per Share
31-Jan-22	Fund A	Class A	100,000	110
28-Feb-22	Fund A	Class A	101,000	111.1
31-Mar-22	Fund A	Class A	102,000	112.2
30-Apr-22	Fund A	Class A	103,000	113.3
31-May-22	Fund A	Class A	104,000	114.4
30-Jun-22	Fund A	Class A	107,000	117.7
31-Jul-22	Fund A	Class A	108,000	118.8
31-Aug-22	Fund A	Class A	109,000	119.9
30-Sep-22	Fund A	Class A	110,000	121
31-Oct-22	Fund A	Class A	107,000	117.7
30-Nov-22	Fund A	Class A	108,000	118.8
31-Dec-22	Fund A	Class A	111,000	122.1
31-Jan-22	Fund A	Class B	95,000	104.5
28-Feb-22	Fund A	Class B	96,000	105.6
31-Mar-22	Fund A	Class B	97,000	106.7
30-Apr-22	Fund A	Class B	98,000	107.8
31-May-22	Fund A	Class B	99,000	108.9
30-Jun-22	Fund A	Class B	100,000	110
31-Jul-22	Fund A	Class B	101,000	111.1
31-Aug-22	Fund A	Class B	102,000	112.2
30-Sep-22	Fund A	Class B	103,000	113.3
31-Oct-22	Fund A	Class B	104,000	114.4
30-Nov-22	Fund A	Class B	105,000	115.5
31-Dec-22	Fund A	Class B	106,000	116.6
31-Jan-22	Fund B	Class C	100,000	110
28-Feb-22	Fund B	Class C	101,000	111.1
31-Mar-22	Fund B	Class C	102,000	112.2
30-Apr-22	Fund B	Class C	103,000	113.3
31-May-22	Fund B	Class C	104,000	114.4
30-Jun-22	Fund B	Class C	107,000	117.7
31-Jul-22	Fund B	Class C	108,000	118.8
31-Aug-22	Fund B	Class C	109,000	119.9
30-Sep-22	Fund B	Class C	110,000	121
31-Oct-22	Fund B	Class C	107,000	117.7
30-Nov-22	Fund B	Class C	108,000	118.8
31-Dec-22	Fund B	Class C	111,000	122.1
31-Jan-22	Fund B	Class D	95,000	104.5
28-Feb-22	Fund B	Class D	96,000	105.6
31-Mar-22	Fund B	Class D	97,000	106.7
30-Apr-22	Fund B	Class D	98,000	107.8
31-May-22	Fund B	Class D	99,000	108.9
30-Jun-22	Fund B	Class D	100,000	110
31-Jul-22	Fund B	Class D	101,000	111.1
31-Aug-22	Fund B	Class D	102,000	112.2
30-Sep-22	Fund B	Class D	103,000	113.3
31-Oct-22	Fund B	Class D	104,000	114.4
30-Nov-22	Fund B	Class D	105,000	115.5
31-Dec-22	Fund B	Class D	106,000	116.6

I decided to pivot the "NAV per Share" column, which contains the information for the lines. This creates column for each share class which then can be added to a graph as a separate line.

Date	fund	NAV	Class A	Class B	Class C	Class D
31-Jan-22	Fund A	100,000	110
28-Feb-22	Fund A	101,000	111.1
31-Mar-22	Fund A	102,000	112.2
30-Apr-22	Fund A	103,000	113.3
31-May-22	Fund A	104,000	114.4
30-Jun-22	Fund A	107,000	117.7
31-Jul-22	Fund A	108,000	118.8
31-Aug-22	Fund A	109,000	119.9
30-Sep-22	Fund A	110,000	121
31-Oct-22	Fund A	107,000	117.7
30-Nov-22	Fund A	108,000	118.8
31-Dec-22	Fund A	111,000	122.1
31-Jan-22	Fund A	95,000		104.5
28-Feb-22	Fund A	96,000		105.6
31-Mar-22	Fund A	97,000		106.7
30-Apr-22	Fund A	98,000		107.8
31-May-22	Fund A	99,000		108.9
30-Jun-22	Fund A	100,000		110
31-Jul-22	Fund A	101,000		111.1
31-Aug-22	Fund A	102,000		112.2
30-Sep-22	Fund A	103,000		113.3
31-Oct-22	Fund A	104,000		114.4
30-Nov-22	Fund A	105,000		115.5
31-Dec-22	Fund A	106,000		116.6
31-Jan-22	Fund B	100,000			110
28-Feb-22	Fund B	101,000			111.1
31-Mar-22	Fund B	102,000			112.2
30-Apr-22	Fund B	103,000			113.3
31-May-22	Fund B	104,000			114.4
30-Jun-22	Fund B	107,000			117.7
31-Jul-22	Fund B	108,000			118.8
31-Aug-22	Fund B	109,000			119.9
30-Sep-22	Fund B	110,000			121
31-Oct-22	Fund B	107,000			117.7
30-Nov-22	Fund B	108,000			118.8
31-Dec-22	Fund B	111,000			122.1
31-Jan-22	Fund B	95,000				104.5
28-Feb-22	Fund B	96,000				105.6
31-Mar-22	Fund B	97,000				106.7
30-Apr-22	Fund B	98,000				107.8
31-May-22	Fund B	99,000				108.9
30-Jun-22	Fund B	100,000				110
31-Jul-22	Fund B	101,000				111.1
31-Aug-22	Fund B	102,000				112.2
30-Sep-22	Fund B	103,000				113.3
31-Oct-22	Fund B	104,000				114.4
30-Nov-22	Fund B	105,000				115.5
31-Dec-22	Fund B	106,000				116.6

This approach serves the purpose but when I have my report filtered to only show information for fund A, the legend of the graph still shows share classes C and D even though the values in these column are all blank. Like on the chart below. Even though there are only 2 lines all 4 classes are listed.

Is there a way to filter the empty share classes out without removing them manually from the graph? I would like the report to be dynamic and use the slicer to switch between different funds.

Thank you in advance for all the help !