How to create power BI visual for matrix table from multiple sheets.
Im new to POWER BI. How to create visual for matrox table? I need to create a dashboard with two bar charts, the first of which will display reports by category. Second, the chart will display the product-based report. However, in order to create an interactive main chart, I need to connect two sheets. If you click the corresponding category in the main chart, the second chart will be based on the first chart's selected category. How to do that?
One Column, Many Variables - how to create a scatterplot
Hi All My data has as all variables (eg. revenue, costs, profit) in one column called Variables. In another column, I have all the data called Data. In another column, I have the respective company names, called Company_Names. I wish to create a scatterplot graph, Revenue on x-axis and Costs on y-axis, with Company_names show per data point. How can I create this? Thank you
