Excel dashboard using slicers when cell contains multiple values

0 votes

I'm having trouble setting up the dashboard in Excel. I have information about sales, clients, and meetings. The type of transaction is listed in one of the columns (for example AAA, BBB, etc). There is often only one type of transaction for each row, but occasionally there are two or even three.

So for example it could look like this:

Invoice Type Price
Invoice_1 AAA 100$
Invoice_2 BBB 200$
Invoice_3 AAA, BBB 500$

I wanna create a dashboard with slicers and Pivotcharts, but when I do slicer based on the Column "Type" it gives me three values to choose from: AAA; BBB; AAA, BBB.

Is there a way around this problem? So Excel could identify this data as simply AAA or BBB (to check if the cell contains a given type of transaction separated by a comma?

Oct 31 in Others by Kithuzzz
• 20,660 points
46 views

1 answer to this question.

0 votes
All values in the column are displayed by an Excel slicer. The slicer displays the three separate values that you have. Excel doesn't somehow understand that "AAA, BBB" implies "both AAA and BBB" in your context. It simply takes the text at face value.

You must tidy up your data so that it has just two values if you want the slicer to display only two values. This can entail splitting up data rows with many types into rows with only one type value each.

I hope this helps you.
answered Oct 31 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Excel formula gives error when write using Apache-poi library in Java

I tested some sample code. The cell ...READ MORE

answered Nov 5 in Others by narikkadan
• 37,660 points
42 views
0 votes
1 answer

Using office scripts to read superScripts characters from a cell in excel online

My understanding is that superscript and subscript ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
21 views
0 votes
1 answer

How to automatically nest rows of an Excel spreadsheet using level values?

More grouping levels have been added to ...READ MORE

answered 5 days ago in Others by narikkadan
• 37,660 points
13 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
101 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
81 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
65 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
71 views
0 votes
1 answer

Repeated excel rows based on a cell with multiple values

You can use this query: let ...READ MORE

answered Oct 20 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

Pass multiple Excel cell values to Power Automate

If you have certain data that you ...READ MORE

answered Nov 20 in Others by narikkadan
• 37,660 points
18 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP