Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
adminclikalia
Frequent Visitor

Different facts at different times in one dashboard

Ey guys, thank for your time. 

 

I have a trouble in the visual I´m working on.  What I need to do is to count different facts like:

- count the number of leads,

- count the number of properties valuated,

- count the number of visits

- count the number of deals closed, and so on.

The problem is that  those calculated measures are in diffferent dates and in different tables and they need to be related to my calendar table. How can I put all of these in one single visual? Looking forward to your answer.

 

thank you.

 

2 REPLIES 2
selimovd
Super User
Super User

Hey @adminclikalia ,

 

you should create a date table and use that in your visuals.

As all the other tables then have a connection to the date table, they all should show a proper result. Take a look on how to create a date table:

https://softcrylic.com/blogs/power-bi-for-beginners-how-to-create-a-date-table-in-power-bi/

 

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

 

Best regards

Denis

 

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

Thank you Denis. One more question here.

 

I made the table date to relate the facts with this table but the thing is that all are combined by the create date but I need to merge also by other dates like the visit date or the date where the offer was approbed by the client. How can I do this? I created a new relationship of these dates with my table date but I can´t finish my query. 

 

Sorry if my english is not perfect. I´m spanish.

 

Thank again for your time.

Regards

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.