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.
Hi, (sorry I'm a novice...) I have created a Measure to return a text string with 6 possible results (depending on which range a calculated result falls into).
In Visuals I can create a table (below) but I can't get any other Visual to show the number of results in each of the 6 result categories (e.g. bar chart; pie chart) - it won't let me drag the Measure into Values to perform a Count of the 6 result categories.
I can get the result if I export to Excel and create a Pivot Table...but I want to be able to show it in a Power BI Visual
Solved! Go to Solution.
What you can do is create a different measure to each category, and put each of those in the chart.
Each measure Would likely be something similar to:
No Sales=
CALCULATE(
COUNT(Table[number]),
FILTER(Table,
[Stock Turn Range] = "no sales"
)
What you can do is create a different measure to each category, and put each of those in the chart.
Each measure Would likely be something similar to:
No Sales=
CALCULATE(
COUNT(Table[number]),
FILTER(Table,
[Stock Turn Range] = "no sales"
)
@dcimcclelland think about it, how would you represent texts in charts? What will be the scale?
You can't use charts to show text as the values.
You can however use Calculation Groups to change the format strings of the result to that ever you want, but the actual values need to be numeric.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |