Forum Discussion
Advocate IHow to show two table data to barchats
The 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.
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
1 Reply
- amitchandak
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