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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Hide Column only if it is selected and total in total column

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 1Company 2Company 3Total Company
1002009001200
2004005661166
30080012332333

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 


1 ACCEPTED 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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

@Anonymous What does your source data look like? If you have Company1, Company2 and Company3 columns then try unpivoting those in Power Query Editor.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@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 CompanyMeasure 1 Measure 2Measure 3Measure 4
1002009001200    
2004005661166    
30080012332333    

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Actually i have 3 companies and other measures
3 companies should Be there when i select from them single or multiple.

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors