Hello everyone, i have 2 data tables. One of them including month, id, status and sales. The other data table includes month, id and Transaction.
What i desire is to show in a clustered stacked column chart the amount of sales, count transtions and status after i have filtered these by the ID number.
Is it possible???
Go to Solution.
You could use this way:
Add two dim tables: Dim Month table and Dim ID table
Then create the relationship as below:
Create three measure for "amount of sales, count transtions and status"
amount of sales = CALCULATE(SUM(Table1[Sales]))
count transtions = CALCULATE(COUNTA(Table2[Transaction]))
Status measure = CALCULATE(SUM(Table1[Status]))
From your screenshot, if it is sum(status)? if not just replace SUM(Table1[Status]) with COUNTA(Table1[Status])
Then use Combo Chart in Power BI, use Month field from Dim Month table as X-axis, ID field from DIm ID table as a slicer.
here is sample pbix file, please try it.
Thank you so much it worked as i needed!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!