cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hrkasno
New Member

Color Separated Graph By user selected item

 

I want color Separated Graph by user selected item.

When no select item Then bar Graph is single color,

When several items selected Then bar Graph is multi-color.

ユーザ選択色分け.png

Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Color Separated Graph By user selected item

Hi @hrkasno,

For your requirement, we can not achieve it to date. If nothing is selected by the slicer, the graph will be splited by all items, we can not set the default value. Please comment on the ideas below.

Slicer default selected values
Default Selected Slicer or Tile-By Value Configuration

Best Regards,
Angelia

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Color Separated Graph By user selected item

Hi @hrkasno,

 

Please add the [item] column as Legend level. It will show as your second screenshot displayed.

Best Regards,
Angelia

hrkasno
New Member

Re: Color Separated Graph By user selected item

Hi, @v-huizhn-msft

thank you for answering

 

When you add the [item] column as a legend level, it is always split by [item].
But this is not what I want.

 

If nothing is selected by the slicer, it becomes a graph of a single color,
When choosing with a slicer, I want to divide it by that [item].

 

Is it possible.

Microsoft
Microsoft

Re: Color Separated Graph By user selected item

Hi @hrkasno,

For your requirement, we can not achieve it to date. If nothing is selected by the slicer, the graph will be splited by all items, we can not set the default value. Please comment on the ideas below.

Slicer default selected values
Default Selected Slicer or Tile-By Value Configuration

Best Regards,
Angelia

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors