# Basic of Power BI

To see what the original data looks like, click on 'Transform data' under Home tab.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703398689707/7936ed75-1c93-4469-92a7-8b236ffb44c5.png align="center")

---

1. Replace value
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703399553573/36124736-8a2c-421a-8259-06d2a1b10c84.png align="center")
    
    Go to Transform data and Replace Value
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703399605491/e6b78036-9e05-4130-80fe-a0e1556780fc.png align="center")
    
    When OK button is not available like this, the data type needs to be changed.  
    (Whole number to Text in this case.)
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703399682421/7ba36e17-a264-415b-aaf0-de4734013eed.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703399733215/95bcaef2-62fd-4ebb-bd79-766e127c49b8.png align="center")
    
2. Another way to change the values
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703400256048/e39ef53b-9dda-4aea-bb6b-eaed4be27b14.png align="center")
    
    click on Conditional Column.
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703400402035/b1428409-b38d-499d-8453-029d4069d292.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703400486399/419ea12f-06e3-47ae-83a1-461c6395ac63.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1703400561918/81a8ea50-8ed1-41f6-a65f-125fbe688210.png align="center")
    
    ---
    
    **Visualization**
    
    Once data organization is done, go back to Report tab.  
    And add graphs and charts.
    
    ---
    
    **Shap Map  
    **File- Option- Preview Features- Tick 'shape map visual'