Forum Discussion
Can't visualize correct values with data table. Need Help.
Hi Friends,
Im new at Power Bi, so i apologize for any inconvenience.
I created a data table and the relations between the tables, but when i try to see it, it jsut gives me the total.
Data =
VAR Days = CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2018, 12, 31 ) )
RETURN ADDCOLUMNS (
Days,
"Year", YEAR ( [Date] ),
"Month Number", MONTH ( [Date] ),
"Month", FORMAT ( [Date], "mmmm" ),
"Year Month Number", YEAR ( [Date] ) * 12 + MONTH ( [Date] ) - 1,
"Year Month", FORMAT ( [Date], "mmyyyy" ),
"Week Number", WEEKNUM ( [Date] )
)
On the left side i have the one without the data table, and it shows me correct, and on the other side it just gives me the total.
1 Reply
The relationship is not working. Check that the data types of the two fields are the same. Check the filter direction.
Easiest way to test is to add the date field from calendar table and date field from Fact table in a visual. The columns should match
