cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wjenkins3811 Frequent Visitor
Frequent Visitor

Filtering

Hello,

I would like to set up a seperate dropdown to where I can select either Dark Mode or Live Mode. We have several catergories that fall under Dark Mode and the same categories that fall under Live Mode. I already have a drop down labeled Queue Name. I would like a seperate drop down that shows only Dark and Live mode.

Example queue:

Classification - Offsite (Dark Mode)

Classification -  Text

Classification - Title

Classification - Title (Dark Mode)

 

Seperate slicer i would like 

Dark Mode

LP or Live

1 ACCEPTED SOLUTION

Accepted Solutions
wjenkins3811 Frequent Visitor
Frequent Visitor

Re: Filtering

I'm unable to put the whole file on here for security purposes however the column labeled queue name is the column I am trying to pull live mode and dark mode. There is nothing to differeintiate live mode other than it being blank. I also updated my formula per your findings but still came out blank.  thanks again

 

I was able to resolve the issue. Thank you for all your help.

CustomColumn = IF(
ISERROR(
SEARCH("A", TableName[ColumnName])
),
"A",
"B"
)

 

View solution in original post

4 REPLIES 4
rajendran Super Contributor
Super Contributor

Re: Filtering

Create 2 calculated column

 

Darkmode = IF(Table1[Mode]="Dark",Table1[Calssification_Type])

Livemode = IF(Table1[Mode]="Live",Table1[Calssification_Type]).

 

This will list the categories in each mode.Then apply slicer on these 2 columns.Hope this is what you are looking for.

 

Thanks

Raj

wjenkins3811 Frequent Visitor
Frequent Visitor

Re: Filtering

Raj,

Thank you for your response. When looking at the columns using the Data tab, Im only see blank fields for both created columns of Darkmode and Livemode . Here's what i typed in. I shortened the name of my tables. 

Livemode = IF(table_P_CLASSIFICATION[queue_name]="Live Mode",table_P_CLASSIFICATION[queue_name])

Darkmode = IF(table_P_CLASSIFICATION[queue_id]="Dark Mode",table_P_CLASSIFICATION[queue_name])

My apologies I am new to power bi. 

rajendran Super Contributor
Super Contributor

Re: Filtering

You have used Queue id in one formula and Name in another one. Could you please some sample data ? Or you can attach the sample PBI file as well.

 

Thanks
Raj

wjenkins3811 Frequent Visitor
Frequent Visitor

Re: Filtering

I'm unable to put the whole file on here for security purposes however the column labeled queue name is the column I am trying to pull live mode and dark mode. There is nothing to differeintiate live mode other than it being blank. I also updated my formula per your findings but still came out blank.  thanks again

 

I was able to resolve the issue. Thank you for all your help.

CustomColumn = IF(
ISERROR(
SEARCH("A", TableName[ColumnName])
),
"A",
"B"
)

 

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors