Advanced Microsoft Excel Dashboards with ChartGPT: Leveraging AI for Data Analytics (part-2)

[@sakshisavardekar5492]

When is the next part gonna release for the further dashboard

[@datalab365]

All the parts are there

[@sakshisavardekar5492]

@@datalab365 Can u pls paste the link to the part-3 of these series

[@franckbatty3668]

Merci beaucoup pour vos vidéos Mr. Pourriez vous aussi publié les vidéos en français svp merci

[@TusharKadu-xl1st]

can you help me ..i was converting date time into am and pm then also in my powerbi am and pm is not showing..afterward i converted that column into dddd/mmmm/yyyy hh:mm AM/PM in excel and then again i uploaded into power bi then also itis not showing..can you make the video on how to convert date/time into AM/PM

[@bejukacarlson6454]

Hi.
i suggest you connect the original data into power bi, without making any changes.

[@bejukacarlson6454]

Hello.
When replacing the font color for Total Passengers and Avg Passengers (at 34:01), an error usually pops up which says "The formula is missing a range reference or a defined name.
And what possible solution do you suggest?

[@atebebe2999]

I had encountered the same issue, I resolved it by doing the following. Select any cell within the existing PivotTable , then Go to the Pivot Table Analyze Tab > PivotTable > Option >Uncheck the Generate GetPivotData option.

[@AhmedSaeed-kz8uc]

can you give me another way to get time groubs without chat gbt because the code extracted is not valid with me ?

[@datalab365]

let
TimeValue = Time.From([Time]), // Adjusting to the correct case
TotalMinutes = Time.Hour(TimeValue) * 60 + Time.Minute(TimeValue),
GroupNumber = Number.RoundDown(TotalMinutes / (5 * 60)),
GroupStartHour = GroupNumber * 5,
GroupEndHour = (GroupNumber + 1) * 5,
// Convert to 12-hour clock format
GroupStart12Hour = if GroupStartHour = 0 then 12 else if GroupStartHour > 12 then GroupStartHour - 12 else GroupStartHour,
GroupEnd12Hour = if GroupEndHour = 0 then 12 else if GroupEndHour > 12 then GroupEndHour - 12 else GroupEndHour,
// Determine AM or PM
GroupAMPMStart = if GroupStartHour < 12 then "AM" else "PM",
GroupAMPMEnd = if GroupEndHour < 12 then "AM" else "PM",
// Create the formatted result
Result = Text.From(GroupStart12Hour) & ":00 " & GroupAMPMStart & " - " & Text.From(GroupEnd12Hour) & ":00 " & GroupAMPMEnd
in
Result