Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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.
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
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
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 65 | |
| 64 | |
| 49 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 119 | |
| 117 | |
| 38 | |
| 36 | |
| 27 |