Forum Discussion
Card Visual lock in place
Hi SB4
I'm afraid this is not supported in Power BI. Why not add a column that has values to be displayed in card visuals to the data table and use it for the column headers in the Matrix?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
HI v-jingzhang Thank you for your suggestion. The reason I wanted to use the cards as headers is so they can dynamically change based on the slicer selection of year.
So, when the user selects Nov 2022 for example, we will show prior 12 months based on that selection. When the user selects Oct 2022, we will show prior 12 months based on that selection. I'm not sure your solution can do that?
- v-jingzhang3 years agoCommunity Support
Hi SB4
Are your current "CurMonth-12"/"CurMonth-11"/"CurMonth-10" from a column in a table or measure names? If they are column values, it may be possible. Can you provide some dummy data to show the table you have? Do you have a date table in the model? If possible, providing a sample pbix would be better. How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Jing