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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
carogomez
Helper I
Helper I

probems to see all the information of the same day

HI!

 

I'm trying to do a calendar in pbi with basic information about name of the activity, day and hour.

However, the information of the activities only consider one in a day, so, if i have more of one activity in a day, pbi only consider the first one.

How can i solve this problem?

 

Captura de Pantalla 2020-11-24 a la(s) 17.14.11.png

 

 

 

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

Hi  @carogomez ,

 

Is your issue solved?Does my suggestion work ?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

v-kelly-msft
Community Support
Community Support

Hi @carogomez ,

 

You need to custom the tooltips,see below :

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

edhans
Super User
Super User

Hi @carogomez - use the CONCATENATEX() function in your measure. For example:

 

All Events = 
CONCATENATEX(
    'Table',
    'Table'[Event], ", " & UNICHAR(10)
)

 

It takes this raw table:

edhans_0-1606258978382.png

and returns this Table Visual:

edhans_1-1606259019017.png

The UNICHAR(10) adds a line feed at the end. You can skip that if you want your events on one row.

 

If that isn't what you need, please provide sample data per links below and expected output - an Excel screenshot or something.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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