Dynamic measure on the x-axis in simple bar chart diagram

[PowerBINewbie66]

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

[v-eachen-msft · Accepted 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.

[PowerBINewbie66]

Thanks for your help! /C

[PowerBINewbie66]

A clarification, the x-axis contains the hour banding groups/percentiles where 10%, 25%, 50%, 75%, 90% and 100% of the journeys fall withing