Forum Discussion

ecroke's avatar
ecroke
Frequent Visitor
9 years ago
Solved

Calculated fields in text boxes

This is the document in which I have to transfer into Power Bi. The aspect I am having problems with is outlined in a red box. You must be able to enter data into the “No. of Days in Bin”, “% Increas...
Need Help
Show and Tell
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi ecroke,

    Do you have resource data? You need to load the data from web? If it is, please Get Data->From Web->Type URL, and load the table needed, more details, please review this article. 

    In Power BI desktop, we can not create visual like the box(you can type value into box). You can create a slicer including one field, and you can select a value in slicer, and filter the report.

    >>eg. 9 days in “No. of Days in Bin” means it will look back on the previous 9 days and so on.

    You can create a new table including No. of Days in Bin, and create a slicer including it.

    If you date is continuous, you can create a measure using DATEADD function like the formula. You can refer to this blog.

    Nine Day back =CALCULATE(sum(Table[sale]), DATEADD(Table2[date],-9,Day)))

     
    For color formating, you can use conditional formating in Table or Matrix visuals.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi ecroke,

Do you have resource data? You need to load the data from web? If it is, please Get Data->From Web->Type URL, and load the table needed, more details, please review this article. 

In Power BI desktop, we can not create visual like the box(you can type value into box). You can create a slicer including one field, and you can select a value in slicer, and filter the report.

>>eg. 9 days in “No. of Days in Bin” means it will look back on the previous 9 days and so on.

You can create a new table including No. of Days in Bin, and create a slicer including it.

If you date is continuous, you can create a measure using DATEADD function like the formula. You can refer to this blog.

Nine Day back =CALCULATE(sum(Table[sale]), DATEADD(Table2[date],-9,Day)))

 
For color formating, you can use conditional formating in Table or Matrix visuals.

Best Regards,
Angelia