Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Modelling question

Hi,   I might need some insight on how to model the next analysis. I have two tables: "Reservations" and "Dealers" Each table has Latitude and Longitude coordinates and I would like to plot both ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

Can please share some dummy data with a similar data structure with expected results to test?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, 
    Thanks for answering thus far.
    Here is a view of what the data looks like.

    DealerReservation

     


    As mentioned in my first post, I have to plot this data on a map visual.
    The part with which I'm struggling is when the user would select a Year.
    Only reservations have a date column and dealers don't, if your user would select a year this would filter out the Dealer data and this is not what I would like to achieve.

    I would like to show the dealers always and based on the selection on date it need filter out the reservations.
    In Power BI I have already combined the 2 tables, but I can't figure out how I can write a measure which does this.

    Below are the results that I expect.
    I have achieved this by creating 2 different measure (for the left table visual), but since map visuals don't allow 2 series, I need to solve this in 1 single measure.

     

     

     

    KR,

    Kevin