The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have some data which looks like this:
I need to add a slicer in the report view that only shows SINGULAR options, for example:
Bedfordshire Borough Council
Cambridgeshire County Council
Suffolk County Council
Peterborough City Council
etc.
etc.
I CANNOT split the column into additional rows because that will ruin all my visuals. The number of rows MUST remain the same, as each row pertains to a unique road.
Any help would be greatly appreciated!!
Solved! Go to Solution.
Hi
Intersting task. I created I sample file but cannot find a way to upload it (wasn't this possible a while ago?). I hope my description and screenshots help.
Steps
Please let me know if this was helpful.
Thanks.
JJ
Hi
Intersting task. I created I sample file but cannot find a way to upload it (wasn't this possible a while ago?). I hope my description and screenshots help.
Steps
Please let me know if this was helpful.
Thanks.
JJ
Hello DoubleJ,
Your solution worked. Thank you so much!! 🙂
User | Count |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |