Forum Discussion

117325's avatar
117325
Frequent Visitor
7 years ago
Solved

Data Format Issue when connecting Smartsheet with Power BI

Our team is working on a dashboard with data directly connected to Smartsheet Data. We have correct data formats on the Smartsheet data source (i.e. whole number with no decimal point, $ for currency...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi 117325 

    You could go to Edit queries, create a conditional column

    Then change its type to "Number"(whole number or decimal number as you like)

    Apply &close, go to report view, you could create a measure as i provide before to show the currency format.

    Measure 2 = FORMAT( MAX('Sheet2$'[spend]), "Currency")

    You could download my pbix to see more details.

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

117325's avatar
117325
Frequent Visitor
7 years ago

Adding screenshot of the cost column with the mixed values

 

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi 117325 

You could go to Edit queries, create a conditional column

Then change its type to "Number"(whole number or decimal number as you like)

Apply &close, go to report view, you could create a measure as i provide before to show the currency format.

Measure 2 = FORMAT( MAX('Sheet2$'[spend]), "Currency")

You could download my pbix to see more details.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.