Time problem in Visualization

[Firrhos]

Hello,

I have 8 different tables which are all connected through different columns. In one table, I have calculated Revenue and created a new column to show it. However, when I visualize it on report part, the Date does not work properly.

The 2 tables in question are connected via another table I created with a UniqueID (since Many:Many is not possible) that is present in both tables. My Measure with Revenue looks like SUMX(TableName; [UnitPrice] * [Quantity] * (1-[Discount])). Each row has an ID  and that ID is supposed to be identified in the second table to relate to the Date in another column.

When I add the Date, it just shows the Total Revenue for each year/month, there are no differences. While in Qlik Sense it automatically identified everything and made a normal graph Revenue by Year/Month.

Thanks for your help.

Firrhos

[v-yulgu-msft]

Hi @Firrhos,

---

When I add the Date, it just shows the Total Revenue for each year/month, there are no differences. 

---

You may need to drag [Date] from bridge date dimention table to visual.

Regards,

Yuliana Gu

[Firrhos]

Managed to solve it on my own. Thanks.

[v-yulgu-msft]

Hi @Firrhos,

Glad to hear that it has been resolved. Would you please kindly share your solution so that it can benefit more users?

Thanks,

Yuliana Gu

[Firrhos]

So, it's hard to explain exactly without showing my tables, but I fixed some of the relationships between the tables and it works now. It's all about relationships. 🙂 If you want to know more, I can show you in pm.

Firrhos

[Greg_Deckler]

Will need to see sample data and expected results. Tough to comprehend what is going on without it. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490...

I have written some Quick Measures that may or may not be of use, can't really tell with the information presented:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364