Find Jobs
Hire Freelancers

Create slicer in Microsoft PowerBI to filter rows based on keywords in a field

$250-750 USD

Closed
Posted over 4 years ago

$250-750 USD

Paid on delivery
PowerBi Slicer Using Subset of Field 1. The datasets are flat CVS files, with the metrics, containing sales data, in one dataset and the dimensions, containing fields such as product description, brand and category, in a separate dataset 2. Currently we filter our data with slicers like Description, Brand and Category using a relationship from the Dimension table to the Metric table. 3. We have a Field called TagName in the Dimension table that has a lot of space delimited keywords in it like “Sum98 NeedReturns JustDemo Sum987,” the keywords are variable per row. 4. Each of those space delimited keywords (Tags) are a Dimension This job: 5. Add a slicer based on the space delimited keywords in the TagName field. 6. We can provide a table (TAGS table) with all unique keywords, if this is needed 7. Use the word BlueMagic in your offer, and state briefly how you would go about doing this. and you can send some samples of what you did. 8. We will provide a PBIX with the above mentioned datasets. The job would be to create the needed code and etc. in the provided PBIX file. Create a slicer visual (either using the TAGS table mentioned in number 6 or other eficent method) that would filter the Dimensions table based on the space delimited keyword in the Metric table. It should neatly fit into our theme we use now and it should work fast.
Project ID: 22346940

About the project

18 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Brooklyn, United States
4.8
98
Payment method verified
Member since Feb 16, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.