Forum Discussion
Grouping different columns for counting in a visual
Hello thenk you for ths pbix. I have added several things to you report :
1. A Date and Country columns to the data table
2. A Calendar table
3. A relationship 1-* between Calendar table and Date column, and a relationship 1-* between Id column in Data table and id in Grouping Table.
4. A bar chart showing how many Id by selected country and a date slicer (by year).
When I select a year only rows with this date are selected and the grouping table is recomputed.
The same occurs when I select only a Country from within the bar chart.
So the content of the UNION table is dynamically filtered through the id column.
How can I upload this report ? It seems I'm not allowed to do that.
Community SupportHi , Anonymous
You can take a try to create a new table and build a relationship between tables:
New Table =
UNION (
SELECTCOLUMNS ( 'Table', "ID", 'Table'[Id], "Column", 'Table'[Col1] ),
SELECTCOLUMNS ( 'Table', "ID", 'Table'[Id], "Column", 'Table'[Col2] ),
SELECTCOLUMNS ( 'Table', "ID", 'Table'[Id], "Column", 'Table'[Col3] )
)
You can check my sample pbix file for more details.
Best Regards,
Community Support Team _ Eason
Hello thenk you for ths pbix. I have added several things to you report :
1. A Date and Country columns to the data table
2. A Calendar table
3. A relationship 1-* between Calendar table and Date column, and a relationship 1-* between Id column in Data table and id in Grouping Table.
4. A bar chart showing how many Id by selected country and a date slicer (by year).
When I select a year only rows with this date are selected and the grouping table is recomputed.
The same occurs when I select only a Country from within the bar chart.
So the content of the UNION table is dynamically filtered through the id column.
How can I upload this report ? It seems I'm not allowed to do that.