Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
76 | |
75 | |
70 | |
47 | |
41 |
User | Count |
---|---|
64 | |
41 | |
31 | |
30 | |
28 |