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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pgarcia
Frequent Visitor

Relation to identify events in a date

Hi all!

 

Currently, I'm working for a hotel chain and I want to do a report with a chiclet slicer (or normal slicer) that show the date, when there is a important event show a asterisk too.

 

I have the next source:

Fact

Date               Hotel            Fact

20191101          400                1.000

20191102          400               999 

20191101          100               500

       

Event

Date               Hotel            Event   Image URL

20191101         400                AAA        url asterisk

 

Date               

Date                  Month

20191101            11

20191102            11

 

Hotel

Hotel

400

100

 

And  I want this

 

Report.PNG

 

But When select a day that no have event the graphic is blank, only filter if I select a day with event or the whole month

Report filter.PNG

 

I have the next relations.

 

Relation.PNG

 

How could I add to the date something that identifies an event and filters any day?

 

 

Many thanks.

 

Best Regards

 

 

6 REPLIES 6
Anonymous
Not applicable

Hi,

 

you can add a Day column in your Date table. This column you add in the selection/slicer. So the selection/slicer only shows the Days of an event.

 

BR

Timo

Hi @Anonymous 

 

Many thanks by the answer.

 

I want that it show all days (previous filtered by month) and if the day has a event , remarked it.

 

And When I select a day that  have or don't have event, filter the graphic.

 

Now if I select a day that don´t have event , the graphic show blank.

 

Best regards 

Anonymous
Not applicable

Hi @pgarcia ,

 

could you upload your .pbix ?

 

As far as I understand.

 

1. You want to highlight the days of an event.

2. If you select a day with an event the is filtered.

 

What should happen if you select a day that don't have an event? Which data should be visualized?

 

Best regards

This is the .pbix.

 

https://www.dropbox.com/s/skdznoar2vrej27/Comparativo%20ventas%20Eventos.pbix?dl=0

 

 

The day with event is highlighted in the slicer 

 

But The problem is  When I select a day without event, The graphic is no filtered.

 

And it should be visualized the total of the day selected . (Comparative between different years).

 

 

Many thanks.

 

Best regards

 

 

@Anonymous 

Anonymous
Not applicable

Hi @pgarcia ,

 

sorry but I don't get access to it. Perhaps @v-juanli-msft has a solution for your problem?!

 

BR,
Timo

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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