Reffering to a named value in dynamic text box & rounding chart values

[Anonymous]

Hey guys, 

I've been searching a fair amount of time to find an answer to those 2 issues I'm facing with my Power BI report.

First, I'm trying to create dynamic text that will change based on the slicer I use. To do so I use the "Create a dynamic value that update with you data" feature. I manage to get most of them right by formulating my questions to the AI bot but sometimes the value I'm looking for is based on more than 2 variables and then the AI just gets completely lost. All my values are named and I'm wondering if I can use the results of one of those value for the calculation of another value. (For example : using top_rent_amenity to calculate the project_number_affected)

I've tried many different formulation for the question and it returns something random everytime. In this case, TOP_RENT_AMENITY is the amenity FR with the highest average rent.

So if there's a way to perform this, I would be very happy. 

Then, 

I'm looking to round the end results of a calculation that appears in a chart. I know how to round the individual values through measures & calculated columns but what I'm looking for here is to keep my values intact but to round the summarization that happens in the chart. I can't seem to find where that happens. Please see pictures below : 

Let's say in this chart I'd like the numbers to be rounded to the nearest 0.05 so that this 2.94 would be 2.95 and the 3.98 would be 4.00. Is there a way to achieve this ? 

Thank you all in advance for your time, it's really, really appreciated.

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

1  Dynamic text is a measure result, so, if you want to control the measure to get what you want, you can modify the filter context for this measure. If you want to the dynamic text1 changed depend on another text2, you should use IF/SWITCH funtion to change context.

For instance: 

Top_rent_amenity= max('table'[values])

Project_number_affected =

IF( [Top_rent_amenity] >100,

calculate(count('table'[projectID]),'table'[values] =110),

calculate(count('table'[projectID]),'table'[valeus] = 90 &&'table'[values]=80))

Just a sample. So, the project_number_affected result is depended on Top_rent_amenity. It hard to figurt out the expression without data. if you need more help, please share example date or pbix file without sensitive data and expect result even if hand draw.

2 Function MROUND(<number>, <multiple>)

In your case, result = MROUND([Measure],0.05)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you !! I'll try those and let you know ! 

For the MROUND, is it really just that ? I thought it would round all my values individually in the measure, not just the end result in the charts.