Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Community, Good Evening. I have a requirement to show all the values for a categorical column without a scrollbar.
I created my chart with dimensions that had 370+ distinct values and DAX measure and got the below chart. But my business users want to see all the values without scroll bar.
To meet my requirements, I need a dynamic DAX column that holds an index value that can be used in the X-Axis as continuous. But how to write DAX to get such a dynamic index column to change with your selections.
Dimension: Station Name
Measure: Actual Travel Time / Total Time
I have separate facts in the model and too many dimensions as filters in the page.
Thanks
Solved! Go to Solution.
Maybe you can refer to field parameter . Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maybe you can refer to field parameter . Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Community, my requirement is to remove the Scroll Bar for the Categorical Column (Station Name) and show all the values.
I have some experience with other tools and its had much more options to control the scroll bar and there is no option available for Power BI to customize the scroll bar for the categorical columns.
So I trying to create a dynamic column ( I can't use the Measure in the x-axis or sort by column) to create a number column to accomplish this.
Any thoughts?
@datpbi_newbie , You can get a continuous axis for the Number and date field only
Yes we can create continuous on the number and date field only.
So I am looking to create a dynamic Index number column for my string Station_Name column and I use Tool Tip to show the Station Name.
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |