cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dcimcclelland
New Member

Text Measure not displaying in Visual

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).

 

dcimcclelland_1-1651382048724.png

 

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

 

dcimcclelland_0-1651381573990.png

 

1 ACCEPTED SOLUTION
rbriga
Super User
Super User

What you can do is create a different measure to each category, and put each of those in the chart.

See this example.

Each measure Would likely be something similar to:

No Sales= 
CALCULATE(
COUNT(Table[number]),
FILTER(Table,
[Stock Turn Range] = "no sales"
)
-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!

View solution in original post

2 REPLIES 2
rbriga
Super User
Super User

What you can do is create a different measure to each category, and put each of those in the chart.

See this example.

Each measure Would likely be something similar to:

No Sales= 
CALCULATE(
COUNT(Table[number]),
FILTER(Table,
[Stock Turn Range] = "no sales"
)
-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!
SpartaBI
Community Champion
Community Champion

@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.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors