title: Date Format in Power BI Hierarchical Slicer
body: <p>I have a <code>Power BI</code> file that connects to a data model via <code>SSAS</code>. The data model origin is a <code>SQL Server</code> view with some computed columns added in via <code>SSAS</code>.</p>
  
  <p>One of the visualisations is a <code>Hierarchical Slicer</code> that shows dates. The field is not one of the computed <code>SSAS</code> columns. It displays in DD/MM/YYYY format but when I place the file on a <code>Power BI Report Server</code> the format is Americanised to MM/DD/YYYY. I want it to be <strong>DD/MM/YYYY</strong>.</p>
  
  <p>The same field is used to populate a table visualisation but in there it remains DD/MM/YYYY. Just the slicer is affected.</p>
  
  <p>This blog <a href="https://community.powerbi.com/t5/Desktop/date-format-in-slicer/td-p/215627" rel="nofollow noreferrer">https://community.powerbi.com/t5/Desktop/date-format-in-slicer/td-p/215627</a> seemed to have the answer I needed but these settings were already applied and still the slicer shows MM/DD/YYYY. </p>
  
  <p>Its not a problem when I open the pbix file locally; there, the slicer shows the dates as DD/MM/YYYY, its just when its on the server. The same problem persists in Test and Production and I have checked those settings and they are as the blog indicates. Other blogs identify this with the slicers but do not present a  real solution as its not seen as a problem in those topics.</p>
  
  <p>I've only spent a month working with <code>Power BI</code> so have no real experience to draw upon. I know that <code>SQL Server</code> defaults to American English when connecting to a database and I have changed that to British English but still the same problem. How do I get the slicer showing as DD/MM/YYYY as in my local copy?</p>