cancel
Showing results for 
Search instead for 
Did you mean: 
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 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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.