Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
the dataset contains a number of journeys with different length in hours. In a simple clusted column chart, I want to display on the y-axis the number of journeys (as % of total number of journeys) and on the x-axis percentiles which are labelled 1-x for 10th percentile (can be 5 as in the example visualisation below), 1-y for the 25th percentile, and so on, where x, y etc are calculated with the PERCENTICE.EXC DAX-function and will return the max range number for 10%, 25%, 50%, 75%, 90% and 100%-tiles. I.e., the labels on the x-axis are not fixed, but dynamic. It seems it is not possible to put measures that calculate the percentile ranges on it. Or is it possible to achive through some trick (with disconnected tables or similar)?
Kind regards
C
Solved! Go to Solution.
Hi @PowerBINewbie66 ,
In this visual, measure cannot be used as x-axis. You need to convert the measure into calculated columns and create a slicer based on the calculate column to filter the x-axis.
Hi @PowerBINewbie66 ,
In this visual, measure cannot be used as x-axis. You need to convert the measure into calculated columns and create a slicer based on the calculate column to filter the x-axis.
Thanks for your help! /C
A clarification, the x-axis contains the hour banding groups/percentiles where 10%, 25%, 50%, 75%, 90% and 100% of the journeys fall withing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |