Forum Discussion

New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago
Solved

Help - Quirky Data

I connected to a table in Excel; it pulls data from SharePoint (I do not have permissions to directly connect to SharePoint).    My issue is; users can select multiple check boxes on the screen.  W...
Need Help
  • New2PowerBI's avatar
    New2PowerBI
    8 years ago

    Want to give you an update; I was able to solve this after I explained to you what I wanted.  Essentially, I created four Conditional Columns; I set 4 IF statements to pick up the area (to display a True) and then ELSE False.  I did one column at a time and essentially got exactly what I needed.  Thanks again; your questions prompted me to think about the problem differently. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

New2PowerBI ,

Sorry for that I miss the image in my second reply. I edit it, please review the image.

Regards,
Lydia

New2PowerBI's avatar
New2PowerBI
Helper III
8 years ago

Want to give you an update; I was able to solve this after I explained to you what I wanted.  Essentially, I created four Conditional Columns; I set 4 IF statements to pick up the area (to display a True) and then ELSE False.  I did one column at a time and essentially got exactly what I needed.  Thanks again; your questions prompted me to think about the problem differently.