Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Guys!
I am recently doing a project in which i have a requirement from client says that we have 3 companys and in the report the companies column on demand like if we select company 1 then total of company 1 only if we select two 2 companies then only show two companies column and total = Company1 + Company 2
Company 1 | Company 2 | Company 3 | Total Company |
100 | 200 | 900 | 1200 |
200 | 400 | 566 | 1166 |
300 | 800 | 1233 | 2333 |
I have done other things but how to hide column if it is not selected ?
please share your advise and solution Thanks in advance
@amitchandak
@Greg_Deckler
Solved! Go to Solution.
Hi @Anonymous,
You can add if statement to package your measure expression to add conditions check if slicer selected specific values or they will replace to blank results.
ISFILTERED function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
@Anonymous What does your source data look like? If you have Company1, Company2 and Company3 columns then try unpivoting those in Power Query Editor.
@Greg_Deckler
I want to show Company measure when i select company name from slicer else it should be hide.
Company 1 Measure | Company 2 Measure | Company 3 Measure | Total Company | Measure 1 | Measure 2 | Measure 3 | Measure 4 |
100 | 200 | 900 | 1200 | ||||
200 | 400 | 566 | 1166 | ||||
300 | 800 | 1233 | 2333 |
Hi @Anonymous,
You can add if statement to package your measure expression to add conditions check if slicer selected specific values or they will replace to blank results.
ISFILTERED function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
Actually i have 3 companies and other measures
3 companies should Be there when i select from them single or multiple.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |