Create Custom X axis based on constant values and perform matrix for measure columns

Question

Hi,&nbsp;I have a requiremnt to create custom x axis based on constant values and perform matrix. here names are custom values.names dates&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; counta&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01-03-2023&nbsp; &nbsp; &nbsp; &nbsp;1b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;01-03-2023&nbsp; &nbsp; &nbsp; &nbsp; 2c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-03-2023&nbsp; &nbsp; &nbsp;1b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;02-03-2023&nbsp; &nbsp; &nbsp; &nbsp;2

amitchandak · Answer

SravaniBudde ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
&nbsp;
refe, if&nbsp;Field Parameters can help&nbsp;
&nbsp;
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afdPower BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllESwitch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725fAppreciate your Kudos.

Forum Discussion

Create Custom X axis based on constant values and perform matrix for measure columns

1 Reply

Related content

Performance identifying Measure

Performance Boost repetitive Measures

DAX Query Performance vs Nested Measures

Creating constants

DAX performance optimization