Forum Discussion
Create Stacked Column Chart using only measures
- 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
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
Thank you it worked well!. i was using SELECTEDVALUE only for slicers. But today i learned usage of selectedvalue for tables. Thanks a lot :)