Day Name and Month Name missing when publishing to web app

[DaniO]

Hi, 

i´ve created a Tile to show sales by day of the wook and another by Month.

i´ve created DayName and Month Name colums from "Date" Column using PI Desktop (Add Column>Date>Day>Name of Day)

It works well whent using it in Desktop but when i publis the report to the PI Web App the data of that columns is missing.

Other columns like "Monht", "DayOfWeek" work ok.

I´ve tried changing the language configuration from Spanish to English in Web app and the collation of the report in Destop but not result.

Does anyone have experienced a similar issue? Any recomendation?

Thanks in advance and Regards,

Dani.

[v-micsh-msft]

Hi DaniO,

Could you please share more details about the Day Name column here, the formula, and also the related data sample (what the actual data, language used)?

I tested the publish to Power BI service, with a newly created data table, selecting the column for day name works at my side:

The column is written with the following formula:

Column = SWITCH([weekday], 1, "Mon", 2, "Tues", 3, "Wen", 4, "Thu" 

               , 5, "Fri", 6, "Sat", 7, "Sun",  

                "Unknown month number" )

See:

Please try to add related column with the data name column under Edit report View in Power BI service, see if it would make any difference.

Regards