Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys, my name is Mario and this is my first post 🙂
Recetly i stared to work again whit PowerBI. I attack the data from a cube (Analysis Services) and i want to change showed data into a chart.
In this moment i have two charts: one for 'Real income' vs 'Budget' and other for 'Real income amount' vs 'Budget amount'
I want to put both of these chart in the same one. To try to do it i have created this two measures:
gr_BUDGET = IF([Measure_CLICK]=TRUE;[Budget amount];[Budget])
gr_REAL = IF([Measure_CLICK]=TRUE;[Real income amount];[Real income])
Measure_CLICK = TRUE -----> so it shows AMOUNT's;
Do you know if it could be able to do it it a checkbox or button? Other solution?
Thanks a lot!
Solved! Go to Solution.
Hi @Anonymous,
I'd like to suggest you to use slicer to instead, below is sample steps:
1. Create a table as the source of slicer.
SelectTable= UNION(ROW("Name","Combo A"),ROW("Name","Combo B")
2. Write a measure to get the selected item from slicer.
Selected= IF(HASONEVALUE(SelectTable[Name]),VALUES(SelectTable[Name]),BLANK())
3. Write a measure based on selected item.
BUDGET=IF([Selected]="Combo A",[Budget amount],[Budget]) REAL=IF([Selected]="Combo A",[Real income amount],[Real income])
Regards,
Xiaoxin Sheng
Hi @v-shex-msft and thanks for your solution.
Finally i added a new table to the cube NOT LINKED (it was a Analysis Services, i cannot create a new table into Power BI Desktop)
tableName: DimChecker
| FIELD | VALUE | | ------ | ------- | | Monthly | 1 | | Amount | 0 |
Using that table i did one mesasure more
M_checker = IF(VALUES(DimChecker[Value])=1;TRUE();FALSE())
it's working perfect! 🙂 🙂
Thank you so much.
Regards!
Hi @Anonymous,
I'd like to suggest you to use slicer to instead, below is sample steps:
1. Create a table as the source of slicer.
SelectTable= UNION(ROW("Name","Combo A"),ROW("Name","Combo B")
2. Write a measure to get the selected item from slicer.
Selected= IF(HASONEVALUE(SelectTable[Name]),VALUES(SelectTable[Name]),BLANK())
3. Write a measure based on selected item.
BUDGET=IF([Selected]="Combo A",[Budget amount],[Budget]) REAL=IF([Selected]="Combo A",[Real income amount],[Real income])
Regards,
Xiaoxin Sheng
Hi @v-shex-msft and thanks for your solution.
Finally i added a new table to the cube NOT LINKED (it was a Analysis Services, i cannot create a new table into Power BI Desktop)
tableName: DimChecker
| FIELD | VALUE | | ------ | ------- | | Monthly | 1 | | Amount | 0 |
Using that table i did one mesasure more
M_checker = IF(VALUES(DimChecker[Value])=1;TRUE();FALSE())
it's working perfect! 🙂 🙂
Thank you so much.
Regards!