Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |