Forum Discussion
Measures dont drill down correctly
Hi guys,
I'm experiencing a weird problem with my graphs.
I have 2 tables,:
table 1 contains my orders so there is alot of rows with columns of prodcut id, timestamp (date and time) quantity and profit (not shown here).
table 2 contains columns of product id, date and total volume in market in this day.
I want to calculate the sum of my orders /total volume per day and per stock id.
The measure works well only if I use date from table 2 as the date but if I use a dual graph and for example insert profit and orders/volume then the graph breaks.
If I use the timestamp from table 1 then the measure doesn't filters down and showing only 1 value (sum of all)
If I use the date from table 2 then the measure works fine but the profit doesn't filter and stuck on 1 value (sum of all)
what do i need to do make it work?
I guess something is wrong with how pbi understands the date/time but have no idea how to fix it.
You have to create a Date table to work as date dimension and then create the relationship between the Date dimensions and your 2 tables. After that, you use the Date from the Date table and the visual will work.
Here you can find how to create this Date table: https://community.powerbi.com/t5/Desktop/Creating-Date-Tables/td-p/553980
1 Reply
- AleResolver II
You have to create a Date table to work as date dimension and then create the relationship between the Date dimensions and your 2 tables. After that, you use the Date from the Date table and the visual will work.
Here you can find how to create this Date table: https://community.powerbi.com/t5/Desktop/Creating-Date-Tables/td-p/553980