Slicer

mason23 — Wed, 16 Mar 2022 00:58:37 GMT

Hello Community,

How do I put this into a slicer where it has only two selections (yes or no)?

Jan	Feb	Mar	April	May	Jun	Jul	Aug	Sept
Yes	yes	no	yes	yes	no	yes	no	yes
No	yes	no	yes	no	no	yes	no	yes
No	yes	no	no	yes	no	yes	no	yes

Thank you

Re: Slicer

lbendlin — Thu, 17 Mar 2022 00:04:26 GMT

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Slicer

Anonymous — Fri, 18 Mar 2022 03:04:09 GMT

Hi @mason23 ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

1. Add a index column in Power Query Editor

2. Select all columns with month name and unpivot them in Power Query Editor

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WqkwtVtKBknn5cCaGAJwZqxONVRzKJFYLHiPAWmIB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Jan = _t, Feb = _t, Mar = _t, April = _t, May = _t, Jun = _t, Jul = _t, Aug = _t, Sept = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Jan", type text}, {"Feb", type text}, {"Mar", type text}, {"April", type text}, {"May", type text}, {"Jun", type text}, {"Jul", type text}, {"Aug", type text}, {"Sept", type text}}), #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type), #"Reordered Columns" = Table.ReorderColumns(#"Added Index",{"Index", "Jan", "Feb", "Mar", "April", "May", "Jun", "Jul", "Aug", "Sept"}), #"Unpivoted Only Selected Columns" = Table.Unpivot(#"Reordered Columns", {"Jan", "Feb", "Mar", "April", "May", "Jun", "Jul", "Aug", "Sept"}, "Months", "Status") in #"Unpivoted Only Selected Columns"

3. Create a slicer using the field "Status"

4. Create a matrix visual(Rows: Index Columns:Months Values: Status )

If the above one is not your expected result, please provide some raw data(exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file in order to provide you a suitable solution. Thank you.

Best Regards

Re: Slicer

mason23 — Mon, 21 Mar 2022 16:56:35 GMT

Hi,

Thanks for replying. This method is what I expected.

topic Re: Slicer in Developer

Slicer

Re: Slicer

Re: Slicer

Re: Slicer