cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KDS
Helper I
Helper I

Combining different charts into one

I've been asked to recreate a visual my team has in Tableau or find an alternate way of depicting the same data in one visual.

 

The Tableau visual is a combination chart with 3 sections.  The first is table (category, decription, project ID), followed by a stacked horizontal bar chart that depicts the projected and actual budget, and another chart with markers depicting the start/end dates.  This is all ONE chart in Tableau.

 

I can't find anything in PowerBi that would support this.

 

I found a tutorial (www.tutorialgateway.org/add-data-bars-to-table-in-power-bi/.  It's not exactly what I need, but I may be able to leverage it for 2 of the 3 parts... but not sure what I would do about the start/end dates.

 

I can't just overlay two different charts next to each other because the number of entries may differ based on some filter selections and I read that PowerBI doesn't currenlty support syncronized scrolling. 

 

Any creative ideas out there?  

 

Thanks!

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi  @KDS ,

 

There are a couple of options, you can check the APPSource to check if there is a custom visual already created:

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

 

Another option is to use the Charticulator to create your own chart:

https://charticulator.com/ (this is the link of the page but there is a Custom visual for Power BI Desktop)

 

Lastly you can try and get the visualization created using R.

 

https://medium.com/@Konstantinos_Ioannou/how-to-create-an-r-custom-visual-html-for-powerbi-7f2d2e44e...

 


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @KDS,

You can also take a look at the following link 'start date', 'end date' part to know more about handling with date range on multiple date fields.
Before You Post, Read This 

 

Spoiler

You have a “start date” and an “end date” and are trying to know how many of something you have on all of the dates between your date intervals.

Take a look at these two Quick Measures as probably want something like them.

 

Regards, 

Xiaoxin Sheng

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

Hi  @KDS ,

 

There are a couple of options, you can check the APPSource to check if there is a custom visual already created:

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

 

Another option is to use the Charticulator to create your own chart:

https://charticulator.com/ (this is the link of the page but there is a Custom visual for Power BI Desktop)

 

Lastly you can try and get the visualization created using R.

 

https://medium.com/@Konstantinos_Ioannou/how-to-create-an-r-custom-visual-html-for-powerbi-7f2d2e44e...

 


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors