Forum Discussion
Adding Axe category to measure
- 4 years ago
Hello Mannai ,
I am assuming you have three measures as Femmes, Hommes and Key People.
Please follow below steps-Step 1.
Create a table with name MeasureTable and column "MeasrureName" having three rows- Femmes, Hommes and Key People.
Step 2- Create Measure as-
Measure = VAR A = SELECTEDVALUE(MeasureTable[MeasureName]) Return SWITCH(A,"Femmes",[Femmes], "Hommes",[Hommes], "Key People",[Key People])Step 3- In bar chart in axis show MeasureName column from the table created and use above measure in values.
Please mark it as answer if it resolves your issue. Kudos are also appreciated.
Hello Mannai ,
I am assuming you have three measures as Femmes, Hommes and Key People.
Please follow below steps-
Step 1.
Create a table with name MeasureTable and column "MeasrureName" having three rows- Femmes, Hommes and Key People.
Step 2- Create Measure as-
Measure =
VAR A = SELECTEDVALUE(MeasureTable[MeasureName])
Return
SWITCH(A,"Femmes",[Femmes],
"Hommes",[Hommes],
"Key People",[Key People])
Step 3- In bar chart in axis show MeasureName column from the table created and use above measure in values.
Please mark it as answer if it resolves your issue. Kudos are also appreciated.