cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Button chart or possible solution

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!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Button chart or possible solution

Hi @MarioLorenzo,

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: Button chart or possible solution

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!

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Button chart or possible solution

Hi @MarioLorenzo,

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: Button chart or possible solution

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!

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors