Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Power BI experts 🙂
This might be another easy DAX solution for you, but I'm struggling with it.
I have a fact table with test results from a test station that I want to visualize. For the X-Axis I can't use the test execution date/time, because these are not unique and I don't want test results to aggregate. That's why I added an index column in the data source and use that index as the X-Axis.
This index will lead to gaps in the graphical presentation though, because if the user is filtering the data the index will have gaps (see screenshot). Therefore I would need a DAX Measure that will create a dynamic INDEX based on the filter context.
As a result, I would see all the test results next to each other independent of the selected filter criteria.
Whenever I tried something with the RANKX, it just ended up in high CPU utilization and nothing happening (so my formula must be wrong).
Any help would be appreciated 🙂
Thanks guys 🙂
@ferzfeld , In power query you can add an index column
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Hi @amitchandak ,
thats exactly what I did to get a static index column - but depending on the filter settings this index will lead to gaps in the visualizations as you can see here:
I need an index that is dynamic (DAX measure) that I can use for the axis (if that is even possible?)
basically i need to visualize the data each occurence as a data point, the time is not really important here.
@ferzfeld , Based on what I have got so far.
In that case, you have to create a rank measure and an independent series table and join them in a measure
Something very similar to segmentation. But you need = join
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |