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
alme
Helper I
Helper I

Visualize a campaign period in chart

Hi,

 

I have an issue visualizing in a chart a period - say 3 weeks - in which we have a campaign. The purpose is to visualize the impact to the Sales versus LY Sales in the period we have a campaign. I have succeeded in making a combo chart with the sales (bar chart) and a dot (line chart) where the campaigns start, BUT I cannot display the duration of the campaign.

 

Any help is appreciated

 

thanks!

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @alme,

 

>>I have succeeded in making a combo chart with the sales (bar chart) and a dot (line chart) where the campaigns start, BUT I cannot display the duration of the campaign.

Current power bi not support use duration value as the axis of line chart. Maybe you can try to convert them to numeric(total second or other) and drag them to axis.

 

In addition, you can also vote below idea which about add support for "duration" data type.

field of "duration" type

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @alme,

 

>>I have succeeded in making a combo chart with the sales (bar chart) and a dot (line chart) where the campaigns start, BUT I cannot display the duration of the campaign.

Current power bi not support use duration value as the axis of line chart. Maybe you can try to convert them to numeric(total second or other) and drag them to axis.

 

In addition, you can also vote below idea which about add support for "duration" data type.

field of "duration" type

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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.