Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Extract name calculation item from calculation group

Hi all,   I have set up a calculation group using tabular Editor. Users of the report can select one out of 4 measures to evaluate the page. Now I would like to extract the name of the calculation ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    As the document said, these functions are based on the calculation groups. How did you calculate group settings? Did you confirm you have correctly configured these fields and properties?

    If not, you can take a look at the following blog that mentioned about create calculate groups in power bi dekstop:

    Creating Calculation Groups in Power BI Desktop 

    Regards,

    Xiaoxin Sheng

spencerm3's avatar
spencerm3
Frequent Visitor
5 years ago

So I've come up with a terrible work around. 
The new smart text functions of a text box can return the value we're looking for. So visually you can replace your chart title with a text box using smart text. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks, I had the same issues that the resut from the calculation would come up instead of the name. Its not a terrible work around for me, it did the trick 🙂

    • spencerm3's avatar
      spencerm3
      Frequent Visitor
      5 years ago

      The pro is that it got me to learn a little more about Smart Text. 
      the con is that the font I use for the other chart titles (Segoi UI I think) isn't available in Smart text. And it's the Power BI default!