Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to generate sentences referencing data in graphs, e.g. the 32% and 30% in the chart as shown below:
to come out with sentences like "the highest X is [value] at [percent]".
Currently I'm using the Smart Narrative function to add these to text boxes as values:
(the real fields have been replaced with xxxx)
However, I'm having difficulties getting the AI to generate values as percentage of grand total, as well as perform arithmetic operations. Is there a way to generate these numbers as text easily, without the need to rewrite every graph's data and filter contexts as a DAX measure?
Solved! Go to Solution.
You can create a measure using a card visual. Please check my example below:
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
You can create a measure using a card visual. Please check my example below:
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@bleow , Try a measure like
divide(CALCULATE([Measure],TOPN(1,allselected('Table'[category]),[Measure],DESC),VALUES('Table'[category])), [Measure])
or
divide(CALCULATE([Measure],TOPN(1,allselected('Table'[category]),[Measure],DESC),VALUES('Table'[category])), calculate([Measure],all(Table)))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |