Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table (YXEMS2):
I created measures (indicators by formulas):
Result_ind = Count(YXEMS2[result]) * 0.1 / COUNT(YXEMS2[ID])
PapperForm_ind = COUNT(YXEMS2[PapperForm date]) * 0.15 / COUNT(YXEMS2[ID])
Occupation_ind = COUNT(YXEMS2[Occupation]) * 0.05 / COUNT(YXEMS2[ID])
my task:
Each indicator has a maximum score:
Result_ind max score = 0.2
PapperForm_ind max score = 0.2
Occupation max score = 0.06
It is necessary to indicate these points somewhere and create a histogram where the x-axis will be indicators, and the y-axis will be % (for each indicator, a maximum score of 100%)
I hope clearly described the task, help 😃
Solved! Go to Solution.
Mate, on axes you can only place DIMENSION ATTRIBUTES (measures are the values for those attributes and these values are displayed on the other axis; but it's their VALUES that get displayed, not their names). Simple as that. If you want to put the names of measures on the x-axis, then the only logical solution is to have a dimension that stores the names of the measures. Such a table would be disconnected from the model; it would be a parameter table. Once you have it, then you should create a single catch-them-all measure that reacts to what's been selected from the parameter table. This is how you'd build the table/graph you want.
The measure I'm talking about would be of this shape:
[Catch-Them-All Measure] = var __measureNameSelection = SELECTEDVALUE ( Measures[Measure Name] ) var __value = SWITCH( __measureNameSelection, "Measure 1", [Measure 1], "Measure 2", [Measure 2], ... ) return __value
Is it clear? If not, please try to read it all over again and ponder over it for a while 🙂
Best
Darek
Completely unclear what you want...
Are you being surprised you get no answers?
Best
Darek
@Anonymous wrote:Completely unclear what you want...
Are you being surprised you get no answers?
Best
Darek
Created a demo result.
Look here please,
Considering my table, indicator formulas and maximum points of indicators, how can I create such a histogram in Pover BI?
I can find the percentage if I create a measure (measure / maximum score). But this will not help me, since the measure cannot be inserted into the histogram as an axis, only as a value.
help me, Please
Mate, on axes you can only place DIMENSION ATTRIBUTES (measures are the values for those attributes and these values are displayed on the other axis; but it's their VALUES that get displayed, not their names). Simple as that. If you want to put the names of measures on the x-axis, then the only logical solution is to have a dimension that stores the names of the measures. Such a table would be disconnected from the model; it would be a parameter table. Once you have it, then you should create a single catch-them-all measure that reacts to what's been selected from the parameter table. This is how you'd build the table/graph you want.
The measure I'm talking about would be of this shape:
[Catch-Them-All Measure] = var __measureNameSelection = SELECTEDVALUE ( Measures[Measure Name] ) var __value = SWITCH( __measureNameSelection, "Measure 1", [Measure 1], "Measure 2", [Measure 2], ... ) return __value
Is it clear? If not, please try to read it all over again and ponder over it for a while 🙂
Best
Darek
@Anonymous wrote:Mate, on axes you can only place DIMENSION ATTRIBUTES (measures are the values for those attributes and these values are displayed on the other axis; but it's their VALUES that get displayed, not their names). Simple as that. If you want to put the names of measures on the x-axis, then the only logical solution is to have a dimension that stores the names of the measures. Such a table would be disconnected from the model; it would be a parameter table. Once you have it, then you should create a single catch-them-all measure that reacts to what's been selected from the parameter table. This is how you'd build the table/graph you want.
The measure I'm talking about would be of this shape:
[Catch-Them-All Measure] = var __measureNameSelection = SELECTEDVALUE ( Measures[Measure Name] ) var __value = SWITCH( __measureNameSelection, "Measure 1", [Measure 1], "Measure 2", [Measure 2], ... ) return __valueIs it clear? If not, please try to read it all over again and ponder over it for a while 🙂
Best
Darek
It works, thanks.
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
24 | |
22 |