Forum Discussion

anbeegod's avatar
anbeegod
Frequent Visitor
4 years ago
Solved

Create a chart that shows data based on selected column

Hi, I'm switching from Spotfire to Power BI and replicating my previous Spotfire work as training.   One function I'm not quite sure how to do is to show data based on a selected column.   Exampl...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi anbeegod ,

     

    DAX cannot read the column name, so in Power BI you will need to convert the columns into rows by using unpivot feature. Then use Attribute as slicer and Value.1 as legend.

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Super User
4 years ago

anbeegod , If you need dynamic axis with slicer, You need to biikmar or unpivot the columns

 

Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/