cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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!

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!

Super User III
Super User III

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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors