Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sweetstar
Advocate I
Advocate I

How to show two table data to barchats

Untitled.pngThe current bar chat was pretty simple. Just bars, filter, slicers. The data was coming from one table connecting a database. however, I don't have the credential of the database but I can download PBIX modify, and upload back to the BPI service. 

 

Now, I was asked to add an extra CSV saving in SharePoint. The CSV data will be seen as a certain EventType (all row fixed with 'from smartuse') and add besides the previous 2 groups of bars. (I drew blue, green boxes to simulate)

 

I did check the forum. It seems that the only solution is to combine two tables into a new one. But I prefer not to do so, as I cannot apply the data model without the DB credential. Instead, I prefer using a measure. But do correct me if i am wrong.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@sweetstar , You have create a new table in dax for common columns

example

event type = distinct(union(distinct(Table[EventType]),distinct(Table[EventType])))

Other in same way if need. Add date table even needed.

 

Join these with your two tables and analyze with common dimension

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@sweetstar , You have create a new table in dax for common columns

example

event type = distinct(union(distinct(Table[EventType]),distinct(Table[EventType])))

Other in same way if need. Add date table even needed.

 

Join these with your two tables and analyze with common dimension

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.