Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am sharing my Pbix file here.
I was able to get stacked bar group work with a table that is created with "Selectedcolumns" like below.
Slicer (table)
But now, the issue is I need to use the same slicer for Matrix as well, and when I tried using this slicer for Total, it would not display data.
OT or DT: showing data:
Total: Not showing data:
How do I make it work?
Thanks.
Solved! Go to Solution.
Hi @JustinDoh1 ,
Since you apply the Grouping column in the Slicer table as an option on the slicer, please update the formula of measure [Display Measure] as below: replace VAR _Selection= SELECTEDVALUE ( Slier[Selection] ) with VAR _Selection =SELECTEDVALUE ( Slier[Grouping] ). Later see if the matrix below can display the data when the "Total" option is selected.
Display Measure =
VAR _Selection =SELECTEDVALUE ( Slier[Grouping] ) // SELECTEDVALUE ( Slier[Selection] )
RETURN
SWITCH (
_Selection,
"OT",[OT],
"DT",[DT],
"Total", [Total]
// "Total",[OT] + [DT]
)
|
Best Regards
Hi @JustinDoh1 ,
Since you apply the Grouping column in the Slicer table as an option on the slicer, please update the formula of measure [Display Measure] as below: replace VAR _Selection= SELECTEDVALUE ( Slier[Selection] ) with VAR _Selection =SELECTEDVALUE ( Slier[Grouping] ). Later see if the matrix below can display the data when the "Total" option is selected.
Display Measure =
VAR _Selection =SELECTEDVALUE ( Slier[Grouping] ) // SELECTEDVALUE ( Slier[Selection] )
RETURN
SWITCH (
_Selection,
"OT",[OT],
"DT",[DT],
"Total", [Total]
// "Total",[OT] + [DT]
)
|
Best Regards
@v-yiruan-msft Thank you for your help.
It has been a while since I looked into this issue (I went ahead and change to unpivot data as a solution as well), but this is definitely a good resource to use.
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |