Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
PowerVisualBI
Helper I
Helper I

Show Value in Chart from DAX

Hello all
I have a problem with DAX
I have slicer company and month for 3 companies. But there is a need to add one option in the slicer company which is "Consol". When I press the console, then all the values will appear as shown on the donut chart now.

PowerVisualBI_0-1660456757047.png

I need a DAX formula when I press a company in a certain month, then the donut chart will display the revenue from that company (I have made a DAX formula). But if I press the console, it will display all the revenue values of each company.

Actually the choice of the Company Console also has its own value. But I don't show the value, because I want the value for the company console options from the other three companies. 

I just want when I click the console option that appears is the Revenue value of the three companies from the existing DAX formula.

The following is the file
https://drive.google.com/file/d/1nlZhVeagoqqgaCfe5gU6mkKN7Kkd0GYJ/view?usp=sharing

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @PowerVisualBI ,

 

Please consider to create a measure like below to filter the chart:

Measure = IF(selectedvalue('table'[company]) in values('slicer'[company]),1,0)

Add this measure to visual filter and set value = 1

 

Best Regards,

Jay

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

Where did the 'Slicer'[company] come from sir @v-jayw-msft 

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.