This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 36 | |
| 30 | |
| 22 | |
| 22 |