Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I use a Top 3 Measure to restrict column at less than 4 and and LOE Measure to get the X Axis Data. How can I not show the blank columns for the 3 X-Axis Data points?
Solved! Go to Solution.
I solved the issue by adding both Cause and LOE to my X-Axis.
I solved the issue by adding both Cause and LOE to my X-Axis.
If you click the drop-down arrow in the data field of your X-Axis, there should be an item named "show items with no data". Unchecking this may give your intended result
Show items with no data has no effect either way.
Whilst this may not be the perfect solution, you could consider creating a new summarized table, and add a Filter clause to the DAX measure to filter to the TOPN you desire, if that makes sense? So essentially, you should be left with 3 rows for each LOE measure
@bdehning can you share the measure expression?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
To help Cause is used as Legend, X-Axis is LOE 2023 and Count is Y-Axis. I use Top N of 3 for Sort Measure and Top 3 by frequejcy is filter of is less than 4.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |