Create a slicer using multiple columns of a table - NOT NESTED

I want to create slicers that list categories representing multiple different columns in my dataset in a non-nested way. For example, I have in my central demographics table a bunch of columns re...

Need Help

jitendracs2004

Frequent Visitor

3 years ago

Thanks for your help. I have prepared the data in excel. What i have is 5 Dimensions,

Enterprise

service

FE1

FE2

FE3

and 3 measures

MoU

NoUC

NoSC

I want to have a slicers with Enterprise, service and Features (FE1, FE2 and FE3 as values) respectively. If some one select FE1 or FE2 or FE3, only Yes of respective columns get filtered out. User can have multi select option enabled.

Not able to attach the link, so sending the data here itself..

Date	Enterprise	service	FE1	FE2	FE3	MoU	NoUC	NoSC
20230601	Eri000000_1	IPTF	Yes	No	No	10	1	50
20230602	Eri000000_2	DTF	No	Yes	No	12	1	60
20230603	Eri000000_3	DTF	Yes	No	Yes	20	0	10
20230604	Eri000000_4	DTF	No	No	No	21	0	20
20230605	Eri000000_5	DTF	No	Yes	No	16	0	30
20230606	Eri000000_1	DTF	Yes	No	Yes	18	26	12
20230607	Eri000000_2	DTF	Yes	No	No	29	10	14
20230608	Eri000000_3	DTF	No	Yes	No	30	12	15
20230609	Eri000000_4	IPTF	Yes	No	Yes	25	20	10
20230610	Eri000000_5	IPTF	Yes	No	No	16	21	20
20230601	Eri000000_3	IPTF	No	Yes	No	18	16	30
20230602	Eri000000_4	IPTF	Yes	No	Yes	29	18	12
20230603	Eri000000_5	IPTF	Yes	No	No	30	29	14
20230604	Eri000000_1	DTF	No	Yes	No	25	30	15
20230605	Eri000000_2	DTF	Yes	No	Yes	10	25	50
20230606	Eri000000_3	DTF	Yes	No	No	12	16	60
20230607	Eri000000_1	IPTF	No	Yes	No	20	18	10
20230608	Eri000000_2	IPTF	Yes	No	Yes	21	10	20
20230609	Eri000000_3	IPTF	Yes	No	No	16	12	30
20230610	Eri000000_4	IPTF	No	No	No	18	20	12
20230601	Eri000000_5	IPTF	Yes	No	Yes	29	21	30
20230602	Eri000000_1	IPTF	Yes	Yes	Yes	30	16	12
20230603	Eri000000_2	IPTF	No	Yes	No	25	18	14
20230604	Eri000000_3	IPTF	Yes	No	Yes	18	29	15
20230605	Eri000000_4	IPTF	Yes	No	No	29	30	10
20230606	Eri000000_5	DTF	No	Yes	No	30	25	20
20230607	Eri000000_3	DTF	Yes	No	Yes	25	18	30
20230608	Eri000000_4	IPTF	Yes	No	No	16	29	12
20230609	Eri000000_5	IPTF	No	Yes	No	18	30	14
20230610	Eri000000_1	IPTF	Yes	No	Yes	29	0	15

lucadelicio
Impactful Individual
3 years ago
Upload it on wetransfer it is free.
https://wetransfer.com/
Thank you
- jitendracs2004
  Frequent Visitor
  3 years ago
  Thanks.
  https://we.tl/t-jufs4v4x5A
  
  I hope you will get the file
  - lucadelicio
    Impactful Individual
    3 years ago
    Hi ji
    here the link of the pbix
    https://we.tl/t-6Xtz2nj6sQ
    You have to manage two table that corrispond to two parameter.
    They manage you column.
    The first parameter "Columns ever show" is the first column of your table and are show indipendent from the choose of your slicer FE.
    The secondo parameter "Column Parameter" show the column based on the FE slicer.
    A filter of a measure is apply on the table to select only the rows you want.
    So the combination of those things returns your result.
    Not so simply to do, but i did it!
    
    I hope I have been helpful.
    Mark it as a solution if resolve your problem.
    Ciao!

Forum Discussion

Create a slicer using multiple columns of a table - NOT NESTED

Related content

Create custom column based on multiple rows

Create columns group

Sequential Order column based on multiple criteria

Creating multiple Audiences in PowerBI App

Create new Column Using Conditions from multiple other columns