This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 9%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOY%3C/text%3E%3C/svg%3E)
A dynamic table was inserted from power pivot and added a slicer to see 3 types of reports. It works fine, but I have to correct one of the reports. The only way is to convert it into a formula using OLAP tools. Converting DT into formulas, It is not possible to obtain the other reports by selecting through the other slicer buttons. I have tried in several ways, so far it has not been possible to view the other reports, why? Can somebody help me about this situation?
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
This question appears to be about Excel, not SSAS. Anyway, it needs some screenshots for demonstration. I connected a single slicer to several pivot tables, and after converting one of them to cube formulas, the slicer still affected them all.
Hi @Orlando Yaguas , welcome to Microsoft Q&A! Are you create Multidimensional Model or Tabular Model to analysis data in SSAS? If yes, could you please provide the error message?
Or you just using power pivot in Excel? If yes, kindly suggest that please add correct tags for your question that can let you get better help. You can find all products that supported on Q&A forum from this link.