Forum Discussion
Anonymous
7 years agoNot applicable
Create Stacked Column Chart using only measures
I have 3 Tables and created measuers in all these tables, using these measures i want to create a stacked column chart. But, only using measures i cant create it as i need one dimension column. Bel...
- 7 years ago
hi, Anonymous
For your requirement (only using measures to create the visual as you want), It is impossible in power bi for now.
But you could just adjust your formula as below:
Step1:
Add a Sales info fact table.
(only using measures can't create it as it need one dimension column.)
Step2:
Adjust your formula
Sales1 = IF(SELECTEDVALUE(info[Sales info])="Sales Stage", CALCULATE(SUM('Sale Stge'[Amount K$]),FILTER(ALL('Sale Stge'[Sales_Stage]), 'Sale Stge'[Sales_Stage] >=1 && 'Sale Stge'[Sales_Stage] <=2)))Sales2 = IF(SELECTEDVALUE(info[Sales info])="Sales Stage",CALCULATE(SUM('Sale Stge'[Amount K$]),FILTER(ALL('Sale Stge'[Sales_Stage]), 'Sale Stge'[Sales_Stage] >=3 && 'Sale Stge'[Sales_Stage] <=4)) )Sales All = IF(SELECTEDVALUE(info[Sales info])="Sales Stage", SUM('Sale Stge'[Amount K$]))Sales All = IF(SELECTEDVALUE(info[Sales info])="Sales Stage", SUM('Sale Stge'[Amount K$]))Budget = IF(SELECTEDVALUE(info[Sales info])="Budget",SUM(Budget[Amount K$]))
Remaing Budget = IF(SELECTEDVALUE(info[Sales info])="Budget", Budget[Budget] - [Sales M])
for Also give country as a slicer.
You could add a country fact table and then create the relationship with these three tables.
Result:
and here is pbix file, please try it..
Best Regards,
Lin
Anonymous
7 years agoNot applicable
Chart should be as below: