Two columns in one axis?

[elaj]

Hi,

I want to show the filter of two columns in one axis.

It is not possible right?

This is my Data:

ID	wave	Q_1	Filter_1	Filter_2	Filter_2
1	1	1	Brand_1	Grp_1	Grp_2
2	1	2	Brand_1	Grp_1	Grp_2
3	1	5	Brand_1	Grp_1	Grp_2
4	1	10	Brand_1	Grp_1	Grp_2
5	2	3	Brand_1	Grp_1	Grp_2
6	2	0	Brand_1		Grp_2
7	2	0	Brand_1		Grp_2
1	1	18	Brand_2	Grp_1	Grp_2
2	1	3	Brand_2	Grp_1	Grp_2
3	1	7	Brand_2	Grp_1	Grp_2
4	1	20	Brand_2	Grp_1	Grp_2
5	2	1	Brand_2	Grp_1	Grp_2
6	2	0	Brand_2		Grp_2
7	2	0	Brand_2		Grp_2

I want to show Q_1 as values inside of a line-visual.

wave is the axis.

The Filter_1 is at visual level.. so no problem.

The Filter_2 should be the legend... both columns.

But it is not possible to put two fields into the legend.

Do i always have to do it like this?

If so. Is it possible to do it with DAX? I know i could do this in the query editor, but Filter_2 is a result of a calculated column in the Model view.

thanks for your help 🙂

[v-juanli-msft · Accepted solution]

Hi @elaj 

Create a new table

Table 2 =
UNION (
    SUMMARIZE (
        'Table',
        'Table'[ID],
        'Table'[wave],
        'Table'[Q_1],
        'Table'[Filter_1],
        'Table'[Filter_2]
    ),
    SELECTCOLUMNS (
        'Table',
        "ID", 'Table'[ID],
        "wave", 'Table'[wave],
        "Q_1", 'Table'[Q_1],
        "Filter_1", 'Table'[Filter_1],
        "Filter_2", 'Table'[Filter_2.1]
    )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.