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

Get Fabric certified for FREE! Don't miss your chance! Learn more

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
Anonymous
Not applicable

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

Where did the 'Slicer'[company] come from sir @Anonymous 

Helpful resources

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.